This discussion is archived
3 Replies Latest reply: Dec 30, 2012 10:52 PM by Srini VEERAVALLI RSS

bi

908588 Newbie
Currently Being Moderated
hi,
I have some data for each month.say no of transactions for each month.When users selects any two months(from month,to_month) ..trend analysis to be shown with respect to from_month.i.e if from month is march2012 and to month is june 2012 then variation sud be as

month variation
march -
april (data for april-data for march)/data for march *100
may (data for may-data for march)/data for march *100
june (data for june-data for march)/data for march *100



is there any way to do so in pivot table.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points