Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a pivot chart with 3 dimensions, year, month and week.
What expression do i need to use to get week to show as % of month and month as % of year etc.
At present I am using =sum(Total sales) but it is only showing the week and month as a % of the year
Thanks in advance
W
If(Dimensionality() = 3, SUM(sales)/SUM(TOTAL <month,year> sales),
If(Dimensionality() = 2, SUM(sales)/SUM(TOTAL <year,week> sales)))
If(Dimensionality() = 3, SUM(sales)/SUM(TOTAL <month,year> sales),
If(Dimensionality() = 2, SUM(sales)/SUM(TOTAL <year,week> sales)))
Hi,
Try like this
For Week =Sum(Sales)/ Sum( TOTAL <Year,Month> Sales)
For Month=Sum(Sales)/ Sum( TOTAL <Year> Sales)
Regards,
Jagan.