How do i create a Sales Index

[#1]

Hi! Im interested on creating a sales index based on year 2010. I´m using a pivot table so that rows show months and coloms show years.

Im using the following:

(Sum(Sales )) /sum( {1<YEAR= {2010} >} Sales)

But its not working, it just gives mi "1"'s in 2010 column an "-"'s in the other colums

Please help

[daveamz]

Hi,

Try sum(Sales)/Before(sum(Sales),ColumnNo()-1)

See the attached example.

Regards,

David

[sujeetsingh]

See this

[#4]

Can u post the example as an image, i cant open other .qvw as i use the trial version.

Thanks

[Gysbert_Wassenaar]

You can't use set analysis here since you use Year as dimension. You need something like:

if(Year=2010,1,sum(Sales)/before(sum(Sales),Year-2010,1))

[swuehl]

By doing that it divides the value of each month by the whole value of the 2010, and what i want to do is this:

month(i)/month(i,year2010)

Just add your Month field (MES) to the TOTAL field list

Sum(Ventas)  / sum({1<ANO= {2010} >} TOTAL<MES> Ventas)