Topic
  • 2 replies
  • Latest Post - ‏2013-05-13T14:32:51Z by Chris001
Chris001
Chris001
19 Posts

Pinned topic Percentage calculation in Crosstab based on Cube

‏2013-05-04T04:32:51Z |

 

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

  • DaveCummings
    DaveCummings
    72 Posts
    ACCEPTED ANSWER

    Re: Percentage calculation in Crosstab based on Cube

    ‏2013-05-06T20: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
     

  • DaveCummings
    DaveCummings
    72 Posts

    Re: Percentage calculation in Crosstab based on Cube

    ‏2013-05-06T20: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
     

  • Chris001
    Chris001
    19 Posts

    Re: Percentage calculation in Crosstab based on Cube

    ‏2013-05-13T14:32:51Z  

    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