(quarter sales -previous quarter sales)/previous quarter sales prompts from and to qtrs getting as mandatory (user compulsaryneed to enter)prompts coming ffrom bex query

[former_member210043]

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

[former_member210043]

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