How to add a total to a Value Column

[Anonymous]

Hello

I have a matrix.  There are 2 rows, Portfolio and PortfolioText and 2 Values cur_Amount and GBP. 

I'd like to get the totals of all the rows into one final grand total at the botttom of the report but I dont want the individual row totals.

Is this possible?  Otherwise the report looks messy like below

[RAZP]

Yes try with the old format pane to make it easy:

• To turn off the new format pane preview, go to File > Options and settings > Options > Preview features > New Format pane

[amitchandak]

@Anonymous , Switch on- the per row level, then disable for series you do not want

[Anonymous]

Hi

The problem is that i get 3 options, All, Portfolio or PortfolioText.  Turning any of them off doesnt make any change - i still see the subtotals per row

[v-shex-msft · Accepted solution]

Hi @Anonymous,

I create a sample to test with subtotal options, they work well to change the 'total level' visibility when I modify the 'per row total'.

Can you please share a pbix or some dummy data that keep the raw data structure? It should help us clarify your scenario and test.

How to Get Your Question Answered Quickly  

In addition, have you tried to turn off the new format panel and test again with these options at the old format panel?

Regards,

Xiaoxin Sheng