Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
In Properties | Presentation, select dimensions from the list and then enable or disable partial sums for each dimension to get the totalling you require.
Properties ;> Presentation 😆 Subtotals
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
Screenshots are of very limited value. If you want more specific help, I suggest that you post your qvw or a representative sample.
Hi ,
I think you have to go for a customized table for "total" field using value list.
Thanks
Kiran Kumar
Hi ,
No, i have checked that discussion
Mine is different requirement
Hi Kiran,
Could you please guide me through that.
Thanks,
Santosh
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