Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi I have gone through lots of community discussion to find solution to show partial sum in pivot table. All says use aggr function, I am already using that.
Can someone guide what I am missing here
My expression is:-
=FirstSortedValue( [Dim C], aggr(num(rank( COUNT( {$<[Exit Rank] ={'Rank 1','Rank 2','Rank 3'}, Period={'<=$(=max(Period))'},[Year]={"$(=Year(max([Period])))"}>} EMPLID&[Exit Rank]),4)),Dim A,Dim B,Dim C))
This expression is giving right value (I am using Dim A ,Dim B as pivot table dimension).
But it isn't giving partial sum,IF I use Dimensionality function it gives partial sum but values are wrong.
Shivam, it generally helps in these cases if you can attach a sample app, so folks can see the data model as well... If you have any confidential data, use the Settings\Document Properties\Scrambling tab to scramble those fields before posting things, and you can reduce the data included as well.
Regards,
Brett