Jump to content

Calculate percentage for column in custom expression of cross table.

Sony Hejmady

Recommended Posts


1)I have a requirement as shown in the attached sheet where I need :

Total Item % = [Total Item Nr]/Gand Total for that particulart Period and Business.

Ex: As seen in attached screenshot, for Period=2005,Business=Aviation, Total Item %=747/3328=20%.

But I am getting 0% for Aviation with incorrect calculation.

My challenge is I cant add over function in cusom expression.

Calculated column T=Sum([Total Item Nr]) OVER ([Period],[bUSINESS]).

When I add the column T in the custom axes of cross table ,I need to add add again Sum function which is:

Sum(Total Item Nr/T) which is giving me incorrect % .Please help.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...