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

Shivam_Sahu — Sat, 16 Nov 2024 02:53:37 GMT

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.

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

Brett_Bleess — Tue, 20 Aug 2019 21:13:41 GMT

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

topic Re: Pivot table not returning partial sum even after aggr function is being used in QlikView

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

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