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 originalWe 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 originalHi 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.
You could look into PIVOT fuctionality.
You can create a view and use PIVOT (info) inside its Control procedure template code.
PIVOT
rotates a table-valued expression by turning the unique values from one column in the expression into multiple columns in the output. AndPIVOT
runs aggregations where they're required on any remaining column values that are wanted in the final output.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.