15 Replies Latest reply: Sep 7, 2015 8:13 AM by Prashant Sangle

# Sub Total for each Measure per each Dimension

Hi , I need to create a Pivot Table where i am using 4 Dimensions and and Three Expressions (Sales,Members,Revenue)

Among the Last dims are Year and Month and i have brough them to the Top Horizontal , now i need to to show the Total Sum of each expression for all the months in a year and also per year.

Please find the attachement for your reference!!

• ###### Re: Sub Total for each Measure per each Dimension

In Properties | Presentation, select dimensions from the list and then enable or disable partial sums for each dimension to get the totalling you require.

• ###### Re: Sub Total for each Measure per each Dimension

Hi Jonathan, Thanks for your time and reply

But when i do that what i will get is the Total of the related dimensions as one Measure group and which is not my requirement i want the total to be for each measure individually and not as a group.

Please find the attchment for your reference on my requirement

• ###### Re: Sub Total for each Measure per each Dimension

Screenshots are of very limited value. If you want more specific help, I suggest that you post your qvw or a representative sample.

• ###### Re: Sub Total for each Measure per each Dimension

Hi Jonathan,

Please check the attached Excel for your understanding of "My Requirement" and "Qlikview Output" when i select show partial sums for Year and/or Month

Thanks,

Santosh

• ###### Re: Sub Total for each Measure per each Dimension

Hi,

Consider you are using Year , Month as dimension.

Then drag your Month Field below Expression field and go to presentation and select Month ->show Partial Sum

Regards

• ###### Re: Sub Total for each Measure per each Dimension

Hi Jonathan,

Is it possible to display the Month related subtotal Label name for that year ?

like for 2014 year as "2014 Total" and 2015 as "2015 Total" ?

• ###### Re: Sub Total for each Measure per each Dimension

Properties ;> Presentation :> Subtotals

• ###### Re: Sub Total for each Measure per each Dimension

Hi,

Please have a look its similar kind

Pivot Table Subtotal

• ###### Re: Sub Total for each Measure per each Dimension

Hi ,

No, i have checked that discussion

Mine is different requirement

• ###### Re: Sub Total for each Measure per each Dimension

Hi ,

I think you have to go for a customized table for "total" field using value list.

Thanks

Kiran Kumar

• ###### Re: Sub Total for each Measure per each Dimension

Hi Kiran,

Could you please guide me through that.

Thanks,

Santosh

• ###### Re: Sub Total for each Measure per each Dimension

I recently went through one such requirement, where I created the total field like yours manually using split value

I took one dimension and all other I formulated piece by piece.

Thanks

Kiran Kumar

• ###### Re: Sub Total for each Measure per each Dimension

Hi Jonathan,

Please check the attached Excel for your understanding of "My Requirement" and "Qlikview Output" when i select show partial sums for Year and/or Month

Thanks,

Santosh

• ###### Re: Sub Total for each Measure per each Dimension

Hi,

OK convinced the others that there is an alternate way of achieving this and had dragged the Year and Month  columns on to the Y-axis and enabled the SubTotal and which is working fine .

Thanks for the help guys !!

• ###### Re: Sub Total for each Measure per each Dimension

Hi,

Go to the presentation tab, click on each dimension and click on subtotal on top or Bottom.