Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am trying to do Percentage of row total in pivot table, but not getting, any one can plz suggest
my Dimensions NG Category, Type and Expression is Count(NG Category)
Please see below image which is done in Excel Pivot tabel using % rows total option.
Thanks
Rajesh
Please provide sample data
Hi,
what is the issue here?, Just enable the Partial sum on Type Dimension at chart Presentation tab
Are you not using the aggregation function ? because only in that case you wont have the total displayed even when you select Partial Sum option