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

# Pinned topic Percentage calculation in Crosstab based on Cube

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

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

Christian

• 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] )

Thanks

Dave

• 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] )

Thanks

Dave

• Chris001
20 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] )