Thursday, February 16, 2012

Cross Tab - percentage

Hi ,

Pls help me... I am in a fix !!!
I have created a cross tab report. The look likes this -

sales
2005 2006
ABC 10 12
XYZ 22 30
TTT 10 45

TOT 42 87

But my actual require is -

sales percentage
2005 2006 2005 2006

ABC 10 12 23.81 13.80
XYZ 22 30 52.38 34.48
TTT 10 45 23.81 51.72

TOT 42 87

I hope u understand it. The only additional requirement is the percentage. The percentage is calculated as -
2005 : if sales is 10 for ABC, then %age is 10/42*100
2006 : sales is 12 for ABC, then %age is 12/87*100Pls can someone assist me..

No comments:

Post a Comment