How can I create grand total % in Pivot Table as red column?

[panwipa2528]

How can I create grand total % as red column?

[prma7799]

(Sum(GrandTotal) / Sum(Total GrandTotal)) *100

or

Num(((Sum(GrandTotal) / Sum(Total GrandTotal)) *100), '##0')

[panwipa2528]

But Grand total I make from > Presentation> Show Partial Sum

[prma7799]

Or write above expression then go to >> Number >> and tick show in Percentage (%)

[prma7799]

In your application showing two Grand Total What is that?

Please share some sample app.

[panwipa2528]

FYI

[PrashantSangle]

Hi,

Modify your expression like

if(secondaryDimensionality()=0,count(id)/count(Total id)*100,count(id))

or

if(secondaryDimensionality()=0,num(count(id)/count(Total id),'0.0%'),count(id))

To highlight with red color,

Expand that expression- > Background Color write below expression.

if(secondaryDimensionality()=0,Red())

Regards,

Prashant

[prma7799 · Accepted solution]

PFA..