Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a pivot table for which i used partial sums.
The end result is something like this;
I need the total that is circled in black, however i need to remove the totals circled in pink, I have treid dimensionality but all it does is remove all the three totals.
Can anyone please help me with this?
PS. I cannot share the file since i pull data from a local server.
Regards,
Hi,
I posted the question again and found this solution.
We can use the dimensionality() function with an IF (Group='GCC') statement for Group.
This would exclude all Totals except those corresponding to GCC.
It would look something like this,
If
(Dimensionality()>1,Limit
,
If
(Trim(Group)='GCC',
Limit ) )
Hi,
I am not sure if we can achieve this using a Pivot table. But we can achieve the above requirement using Straight Table.
In a staright table we can mention No total in the expression tab for a particluar expression.
I hope this helps you.
Hi,
I posted the question again and found this solution.
We can use the dimensionality() function with an IF (Group='GCC') statement for Group.
This would exclude all Totals except those corresponding to GCC.
It would look something like this,
If
(Dimensionality()>1,Limit
,
If
(Trim(Group)='GCC',
Limit ) )