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

[Anonymous]

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

[sunny_talwar]

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