How to calculate and show a sub total in a Water fall chart?

Anonymous — Wed, 24 May 2017 15:10:15 GMT

Hi QlikView gurus,

I have created a waterfall bar chat that shows Indirect and Direct costs.

Here I want to show individual indirect cost bars , a subtotal for indirect costs, a bar for direct cost and finally followed by the grand total bar.

(Please see the attached image for more clarity)

To get the total I am using this expression " =RangeSum(Above(Column(2)), Above(Column(1)) ) "

However, I am not able to get the sub total ('Total Indirect Costs') If I do, it gets double counted.

Any ideas/thoughts?

Thanks

Re: How to calculate and show a sub total in a Water fall chart?

sunny_talwar — Wed, 24 May 2017 17:27:10 GMT

Would you be able to share a sample where you have been trying it out?