Calculate percentage for column in custom expression of cross table.

[Sony Hejmady]

Hi,

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.