topic Re: Subtotal question. Really simple question. Please help in QlikView

Subtotal question. Really simple question. Please help

jadams123 — Wed, 25 Nov 2020 16:16:04 GMT

Hi I want to be able to total the subtotal amount. How can I do that?

This as you know gives me the Total of the whole column (CY - Territory).

Sum(Total{$<Brand={'xyz'},[Reporting Group]={'xyz'}>}[# Amount])

I would like to know the subtotal amount. How can I do that?

Thanks,

jadams123 — Fri, 08 Mar 2019 12:58:13 GMT

Please note. I am only a front end user and I am using pivot table. If this cant be done in a pivot table how to do it in a straight table.

sunny_talwar — Fri, 08 Mar 2019 13:02:23 GMT

May be this

Sum(TOTAL <Region> {$<Brand = {'xyz'}, [Reporting Group] = {'xyz'}>} [# Amount])

jadams123 — Fri, 08 Mar 2019 13:07:30 GMT

10 Trillion thanks. SOLVED!