calculating sales as a % of dimension total on pivot chart

[warrenpress]

Hi,

How do I calculates sales as a % of the dimension total on a pivot chart with more than 2 dimensions?

For eg, If I have a chart with 3 dimensions, year , month & week, i would like to calculate week as a % of month and month as a % of year.

At present i can only get week as a % of year using =sum(Total sales).

Am i missing something?

Thanks in advance

W

[marcus_sommer]

You could use something like this:

sum(sales) / sum(total <week> sales)

- Marcus