Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
its_anandrjs

How to develop this report in pivot table

How to develop Cumulative percentage calculation.

 

 JanFebMarAprTotalCummulative
A234567267636170432%
B246356167542131157%
C6832686436992293100%

 

 

8 Replies
its_anandrjs
Author

Anyone has an idea for this report

sunny_talwar

What is your expression you use? Do you have a sample we can look at?

its_anandrjs
Author

Hi Sunny,

Attached is the data you can use that one

 

Dimension1:- Dealer

Dimension2:- Month 

Expression:-Sum(Value)

sunny_talwar

So, you are looking to have an additional column with %?

its_anandrjs
Author

Yes right expression is 

 

Expression :- Sum(Total Value) / Sum(Value)

Brett_Bleess
Former Employee
Former Employee

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
Saravanan_Desingh

Dimension: Dealer

Expression (%): 

RangeSum(Above(Total Sum(Value),0,RowNo())) / Sum(Total Value)
Saravanan_Desingh

commQV01.PNG