
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Pivot subtotal by dimensions
How do I get subtotals of sub-dimensions in a pivot table? I have used the 'Show Totals' on all the dimensions, but I need sub-totals by category. Excel attached.
Dimensions:
- Charges_region
- Charges_Location_Name
- If(match(Charges_CPT_Rollup,'New Clinical Patients','Established Clinical Patients','Excisions','Mohs Surgery'),Charges_CPT_Rollup)
Expressions:
- sum({$<Charges_CPT_KeyStatReport={'Y'},Charges_Department={'Clinical','Surgery','Phototherapy','*Unmapped*'}>}quantity)
Thank you.
- Tags:
- subtotal_pivot

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Is your third dimension category? May be enable the sub-total for only your third dimension and disable them for all else?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Sunny - I tried enabling and disabling diff combos for the three dimensions and that doesn't seem to get me what I need. Qlik only gives me a top line total, but doesn't provide a total for each of the New Patients, Established Patients, Repairs, Surgery categories that I need. Should I be using aggr function on this? Thanks.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Enable Show total to the dimension for which you want to display total.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Enable subtotal for Category only and disable it for other dimensions.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try this:
sum({$<Charges_CPT_KeyStatReport={'Y'},Charges_Department={'Clinical','Surgery','Phototherapy','*Unmapped*'}>} total <Charges_Location_Name> quantity)
