# New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for
Did you mean:
Highlighted
Creator

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])

 Region Territory CY - Territory CY - Territory XYX Atlantic XYZ \$1,088,104.54 \$46,691,919.06 Atlantic ABC \$1,130,739.79 \$46,691,919.06 Atlantic Total \$2,218,844.32 \$46,691,919.06

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

 Region Territory CY - Territory CY - Territory Atlantic XYZ \$1,088,104.54 \$2,218,844.32 Atlantic ABC \$1,130,739.79 \$2,218,844.32 Atlantic Total \$2,218,844.32 \$4,437,688.65

Thanks,

J

2 Solutions

Accepted Solutions
Highlighted
MVP

May be this

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

10 Trillion thanks. SOLVED!

3 Replies
Highlighted
Creator

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.

Highlighted
MVP

May be this

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

10 Trillion thanks. SOLVED!