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

[sujeetsingh]

Sendy,

Try this

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

[#3]

The same. Still not working

[sujeetsingh]

plz give a sample

[#5]

i leave u the images

[#6]

Try using (Sum(Sales )) /sum({1<Year= {2010} >} TOTAL Sales)

[#7]

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)

[sujeetsingh]

Sendy please explain that what calculation you want.

Dimension i?

[#9]

(month)/(the same month on 2010)

example

for feb 2012:

feb2012/feb2010

for jan 2013:

jan2013/jan2010

and so...

in a matrix notation where we have months and years

for the position a;b

(month (a), year (b)) / (month (a) ; year(2010) )

[#10]

Hi

Take Month as dimension..

SET vMaxYear=MAX(Year)    //(2013)

sum({<Year={$(vMaxYear)}>} value)/sum({<Year={$(=Max(Year(Year))-3)}>} value)

Regards-Bika