Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to develop Cumulative percentage calculation.
Jan | Feb | Mar | Apr | Total | Cummulative | |
A | 234 | 567 | 267 | 636 | 1704 | 32% |
B | 246 | 356 | 167 | 542 | 1311 | 57% |
C | 683 | 268 | 643 | 699 | 2293 | 100% |
Anyone has an idea for this report
What is your expression you use? Do you have a sample we can look at?
Hi Sunny,
Attached is the data you can use that one
Dimension1:- Dealer
Dimension2:- Month
Expression:-Sum(Value)
So, you are looking to have an additional column with %?
Yes right expression is
Expression :- Sum(Total Value) / Sum(Value)
Best I have is the following Design Blog post, not sure if I am missing something or not, hopefully it may help:
https://community.qlik.com/t5/Qlik-Design-Blog/Accumulations/ba-p/1466581
Regards,
Brett
Dimension: Dealer
Expression (%):
RangeSum(Above(Total Sum(Value),0,RowNo())) / Sum(Total Value)