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