Topic
Pinned topic Percentage calculation in Crosstab based on Cube
20130504T04:32:51Z

calculation percentage
Answered question
This question has been answered.
Unanswered question
This question has not been answered yet.
Hello group !
My crosstab shows:
As measure the Quantity Sold
In the rows the Product Lines + Total Product Lines and Order Methods + Total Order Methods
In the columns the years + Total Years
Now I want to do a percentage calculation in the column that shows the contribution of each rows to the total (pls. see screenshot attached)
The calculation is as follows: [Quantity sold] / total( [Quantity sold] within set [Products] )
The percentage calculation is okay for the rows showing the Product Lines but not for the rows showing the Order Methods.
How do I have to change the calculation, so that the percentage column in displayed correctly in each row.
Pls. find attached a sample report based on great outdoors company cube, Version c10.1.1
Thank you for your help
Christian
Attachments

 Desktop.zip
 62 KB

Re: Percentage calculation in Crosstab based on Cube
20130506T20:32:15ZThis is the accepted answer. This is the accepted answer.Hi,
Use the following:
[Quantity sold] / total( [Quantity sold] within set [Products] , [Order Method] )
This will compute the percentage over all Products and Order Methods.
Thanks
Dave

Re: Percentage calculation in Crosstab based on Cube
20130513T14:32:51ZThis is the accepted answer. This is the accepted answer. DaveCummings
 20130506T20:32:15Z
Hi,
Use the following:
[Quantity sold] / total( [Quantity sold] within set [Products] , [Order Method] )
This will compute the percentage over all Products and Order Methods.
Thanks
Dave
Thank you Dave, it works perfectly !
Cheers
Christian