Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have Pivot Table with 3 Dimensions and 2 Expressions - a number and a percentage. I'm using Partial Sum to get the Total at the bottom (in green), but I only want the number total. How can I remove / hide the percentage total?
Thanks for any help!
The attached file is having security constraint as it has section access could you please share a version without section access
Please check if the attached works
Although its got rid of the data, I want the row to be removed completely for %
Partial sums are grouped at the Dimension Level so a place holder will get created for each expression.
So I dont think it could be removed