Formula based on cumulative figure is not working in SAC

[jain06]

We are using Live connection on BW4HANA.We have already tried creating the divison in Bex query but it is not working as expected and hence we moved to SAC

We have got a measure which is a cumulative figure(Cumulative Total no of HUs).When we are pulling this in chart it works fine but once we create a formula to divide(Cumulative total no of HU/Max number of HU) the numerator is not showing cumulative behaviour

For eg-If you check for May 2023,

Cumulative total no of HU-64

Max number of HU-405

Division -64/405=15.8(and it is showing as 12 %)

sac-query.png

In Table, we can achieve this division using cell reference but user wants to see this in chart only.

Can someone help us why it is showing this kind of behavior.

Thanks,

Shaifali