Grand Totals colum

[Mai_Nashaat]

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

[v-lionel-msft]

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 Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Mai_Nashaat]

No actully, 14 is the summation of targets for this customer 6+8, inoice 9 is 3+6 and so the others

[Mai_Nashaat]

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

[lbendlin]

Set Totals position to "top".

[Mai_Nashaat]

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-msft · Accepted solution]

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 Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Mai_Nashaat]

there's a dummy data of the real data can u help me how can I make a measure or a column to replace it with the grand total of the matrix