Pivot table not returning partial sum even after aggr function is being used

[Shivam_Sahu]

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.

[Brett_Bleess]

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