Forum Discussion
Grand Totals colum
Hi everybody,
I need to change the place of grand totals from the end of the matrix to be the first column in the matrix.
Any idea how to make this
Thanks in advance,
Mai
Hi Mai_Nashaat ,
The current version can not change the position of "Grand total", try to find a custom visual in appsource .
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
7 Replies
- lbendlinSuper User
Set Totals position to "top".
- Mai_NashaatHelper II
I want to do that for grand totals
It exists at the end of the table I want it to be the first column
- v-lionel-msftCommunity Support
Hi Mai_Nashaat ,
The current version can not change the position of "Grand total", try to find a custom visual in appsource .
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mai_NashaatHelper II
I could't find a visual that can be used.
I thought I might solve this problem by creating a quick measure to calculatethe total and remove the grand total from the matrix
I have customers and categories, each customer have sales for each category.
Any hint how can I make his measure also if this applicable or not.
thanks in advance
- v-lionel-msftCommunity Support
Hi Mai_Nashaat ,
Is this what you want?
14+9+1.25
6+6+1
8+3+0.375
...
Please provide a sample data.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mai_NashaatHelper II
No actully, 14 is the summation of targets for this customer 6+8, inoice 9 is 3+6 and so the others