Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I made a pivot table containing the dimensions:
Divisionname
PerformanceWeek
PerformanceWeekday
Expression
=SUM({$< Year = {$(=max(Year))} >}Revenue)/(sum(total?{$< Year = {$(=max(Year))} >}Revenue))
Now I want it to show me like this
mo tu wed th fr sa su
Division1 Week 1 20 10 10 20 20 10 10 100%
2 100%
3 100%
Division2 Week 1 20 10 10 20 20 10 10 100%
2 100%
3 100%
But it shows me like this:
mo tu wed th fr sa su
Division1 Week 1 2 1 1 2 2 1 1 9%
2 3 4 1 1 1 2 2 14%
3 4 etc
Division2 Week 1 2 1 1 2 2 1 1
2
3
100%
I hope it's clear and my guess I don't need to use the total formula in my expression.
kind regards
Hi
You need a qualified total, one of these:
SUM({$< Year = {$(=max(Year))} >}Revenue)/(sum(total <DivisionName> {$< Year = {$(=max(Year))} >}Revenue))
or
SUM({$< Year = {$(=max(Year))} >}Revenue)/(sum(total <PerformanceWeek, PerformanceWeekday> {$< Year = {$(=max(Year))} >}Revenue))
HTH
Jonathan
Hi
You need a qualified total, one of these:
SUM({$< Year = {$(=max(Year))} >}Revenue)/(sum(total <DivisionName> {$< Year = {$(=max(Year))} >}Revenue))
or
SUM({$< Year = {$(=max(Year))} >}Revenue)/(sum(total <PerformanceWeek, PerformanceWeekday> {$< Year = {$(=max(Year))} >}Revenue))
HTH
Jonathan