week compare

[Anonymous]

Dear ALL,

    Please find the attached  xl sheet, in  this we have the data for all weeks from  '1/30' to '6/11' we compare the value of every comming week with startweek value ie by using the formule eg:(week6/11value /week1/30 -1) in xl sheet and convert it into percentage.Please suggest an expression.

[christophebrault · Accepted solution]

Hi,

I attached an example from your data, but i have a licenced edition.

Step to step :

Create a pivot table chart with Date as dimension and others if you want.

Set Date dimension horizontaly in the graph.

Create an expresssion sum(Value) to show the sum for the Date.

Create a second one : sum(Value)/before(sum(Value),columnno()-1,1)-1 and set in % in number

This chart will adapt automaticaly  to your time selection.

[Anonymous]

hi Christophebrault

Thanks for correct replay,it is what i am looking in the abow file.

Thanks

arunreddy

[Anonymous]

Hi Christophebrault,

Is it posible to bring the same values in line chart,how to calculate the

values for before(sum(Value),columnno()-1,1)-1 in line chart.

ie : sum(Value)/before(sum(Value),columnno()-1,1)-1 and set in % in number

Thanks

arunreddy