Show or hide "Show totals" on pivot table

[Hoaile_dev]

Hello,

Do we have any way to Show/hide the Total amount on the dimension of the pivot table.

Example we have 2 dimensions : Profit center and company.

if the profit center P1 have more than one companies ( A,B) => show the total amount.

and if the profit center P2 has only one company A => hide the total amount.

Thanks in advance.

Hoai

[GaryGiles · Accepted solution]

Try this in your measure field:

if(count({$}distinct Company)>1,sum({$} Amount),'')

[Hoaile_dev]

Thanks but that is not I need.