Partial Sum problem

[Prav]

Hi,

I have a pivot table like below. Bold ones are partial sums.

I am struggling with expression 'H'. For 'H', I need to multiply the TOTAL of  'G' which is 173,157.33 with expression 'B' which is 7.94 and then divided by 100. The result for first column should be something like (173,157.33 * 7.94)/100 =13,748.69. But it is showing like 19,589.26 which is incorrect.

Expression 'G'  = E - F.

Can anyone help me on this?

Many thanks.

[Prav]

I have also tried advanced aggregation: sum(aggr(expression,Dimension)) but no use. Can anyone help me on this please?

[Brett_Bleess]

Have a look at the following Help link:

https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/ChartFunctions/NestedAggregation...

The only other thing of which I can think is your needing to use RowNo() or RecNo() in the load script to be sure every row in your data is unique to ensure you get what you want in your calculations.  

Only other link I have is the following that may be helpful related to AGGR:

https://community.qlik.com/t5/Qlik-Design-Blog/AGGR/ba-p/1475149

If you want to search further on the Design Blog area, use the following link:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Hopefully one of these will prove to be helpful.

Regards,
Brett

[sunny_talwar]

What expressions are you using for all the different rows? Can you share a sample to help you better here?

[Prav · Accepted solution]

Hi,

Sorry for late reply. I solved this issue by creating individual variables and added them all.

Thanks.