Could you please help me how to calculate cumulative sum in qlik sense bar chart with 2 Dimensions.
This expression only works for 1 dimension:
rangesum( above( sum([Expression1]),0,rowno()))
I have data like below table where MonthName and Industry are dimensions in chart and Amount is Measure.
Your help is really appreciated.
I have attached a qvf file for you reference. You will see that above code works with only 1 dimension not with 2 dimension.
I am aware of above code and already worked with single dimension in many projects, Issue is when you add second dimensions in x-axis it will not work.
I am not full understanding what you are after? Each month you have different industry?? I guess you are after the totals with 1 dimension?? But I am trying to understand how it would show up in two dimensions?