Sub Total for each Measure per each Dimension

[#1]

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!!

Can you please help me on this issue

[jonathandienst]

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

[Anonymous]

Properties ;> Presentation 😆 Subtotals

[#4]

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

[Anonymous]

Hi,

Please have a look its similar kind

Pivot Table Subtotal

[jonathandienst]

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

[kkkumar82]

Hi ,

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

Thanks

Kiran Kumar

[#8]

Hi ,

No, i have checked that discussion

Mine is different requirement

[#9]

Hi Kiran,

Could you please guide me through that.

Thanks,

Santosh

[kkkumar82]

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