Pivot subtotal by dimensions

[#1]

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:

1. Charges_region
2. Charges_Location_Name
3. 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.

[sunny_talwar]

Is your third dimension category? May be enable the sub-total for only your third dimension and disable them for all else?

[#3]

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.

[shraddha_g]

Enable Show total to the dimension for which you want to display total.

[Anonymous]

Enable subtotal for Category only and disable it for other dimensions.

[#6]

Try this:

sum({$<Charges_CPT_KeyStatReport={'Y'},Charges_Department={'Clinical','Surgery','Phototherapy','*Unmapped*'}>} total <Charges_Location_Name> quantity)