topic Re: Show or hide "Show totals" on pivot table in App Development

Show or hide "Show totals" on pivot table

Hoaile_dev — Wed, 21 Oct 2020 09:49:25 GMT

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 — Wed, 21 Oct 2020 10:44:48 GMT

Try this in your measure field:

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

Hoaile_dev — Thu, 22 Oct 2020 09:32:21 GMT

Thanks but that is not I need.