Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
supriyabiware
Creator
Creator

Cumulative % For stacked Bar Chart

supriyabiware_0-1611834989147.png

 

Hi All 

 

I have a chart with stacked % and formula is as below.

 

=Count(Distinct %Account_ID)/count(total <MonthYear> %Account_ID)

 

 

Now i need to show the cumulative increase in % of the stacked dimension?

 

How can i do it?

 

Thanks & Regards,

Supriya

 

3 Replies
supriyabiware
Creator
Creator
Author

supriyabiware_0-1611835372484.png

 

Should look something like this

Seyko
Partner - Creator
Partner - Creator

Hi Supriyabiware,

Can you attach some sample data?

Regards

Excuse my english, i'm french!
supriyabiware
Creator
Creator
Author

Hello, here is a sample data in excel format. i just need the shown output in Qliksense. Currently i can show cumulative of whole numbers , but 100% stack cumulation is where i am stuck