We wonder if there is a way to show the data in the grid horizontal fashion .This is how we do it now
We want to show the data something like this :
Best answer by Mark Jongeling
View original
Horizontal table entries in grid
This topic has been closed for comments
Userlevel 7
+23
Hi Sulea,
I can think of a couple of ways, but this exact overview is not obtainable I think.
You could create a View where months are columns too, such as month-quantity, month-amount, month-total for every month. Then put a Grid group header above these views with the respective month name. Leaving years as rows, you'll end up with a row per year.
Or vote on this idea of mine:
Maybe there are other ways, so I'll be curious to solutions of others here on the Community.
Userlevel 2
+1
- Vanguard
- 16 replies
-
14 November 2022
Userlevel 7
+23
You can create a view and use PIVOT (info) inside its Control procedure template code.
PIVOTrotates a table-valued expression by turning the unique values from one column in the expression into multiple columns in the output. AndPIVOTruns aggregations where they're required on any remaining column values that are wanted in the final output.
Userlevel 5
+16
Or, at least for Universal, you wait for the editable cube to function. Then you can show your existing list in different forms depending if you put a dimension as a row or column.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.