Collpase View and Expanded View - Total Problem / Values not same

[kiranpatil123]

Hi ALl , 

i Have CollpaseExpanded

I have above collapse and Expanded view of Pivot table 

In Expanded View , Cumulative Reduction achieved YTD = (Baseline Count - 2019 June) / BaseLine Count 

The values are coming fine for each Business Unit wise but when you see total its wrong , it should be (50-75)/50 = -50% but its showing -57%

Also when collapsed View , values are not correct.

I tried Aggr by dimesion but its not working . Please help

[Brett_Bleess]

Have a look at the following link, I think it might help, but I am not sure.  By the way, you posted to the Education Forum, you really want to be posting on the correct Product Forum, I was going to move this for you, but I was not sure if you were talking about Qlik Sense or QlikView in this case.  The Help link is QlikView, but I believe it is applicable to QlikSense as well, but I may be wrong.  Pretty sure you were on the right track, just guessing you had something slightly off, so hopefully the link will help:

http://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/ChartFunction...

Regards,
Brett