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 :
Solved
Horizontal table entries in grid
+1- Vanguard
- 16 replies
Best answer by Mark Jongeling
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.
This topic has been closed for comments
+23Hi 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.
"Wake me up before you low-code"
+1- Vanguard
- 16 replies
+23You 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.
"Wake me up before you low-code"
+16Or, 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.
LEF — Lift. Empower. Fulfill. [lef.digital]
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.