on 12-04-2015 7:30 AM
Hi Experts,
I need too calculate the % increase in the sales for each qtr and need to display in the cross table.
Formula : (sales in respective qtr- previous qtr sales)/previous qtr sales *100
ex. ( sales in 4.2010 - sales in 3.2010)/sale in 3.2010
if prompts user given as from : 20104 to 20113
then
Cross tab :
4.2010 1.2011 2.2011 3.2011
%sales %sales %sales %sales
A 10 11 23 21
B 11 19 5 8
C 3 5 9 10
Please help me it is very urgent......
Thanks
NIkil
HI Experts ,
Please help me in the above requirement. how to calculate the previous Qtr measure value with out using the previous and relative value functions.
Thanks
Regards,
Nikil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.