Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can anyone guide me why my pivot table is not showing Total values?
Segment is a synthetic dimention .
WeekInMonth | Day | Segment | a | b | c | d | e | f | g | h | i | Total |
Week1 | Sun | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | |
Week1 | Sat | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | |
Week1 | Fri | 0 | 24 | 0 | 3,144 | 766 | 0 | 0 | (862) | 0 | - | |
Week1 | Thu | 0 | 0 | 0 | 36 | (144) | 0 | 0 | (143) | 0 | - | |
Week1 | Total | 0 | 24 | 0 | 3,180 | 622 | 0 | 0 | (1,004) | 0 | - | |
Week2 | Mon | 0 | (144) | 4,392 | 11,777 | 1,018 | 0 | 84 | (42) | 0 | - | |
Week2 | Sun | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | |
Week2 | Sat | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | |
Week2 | Fri | 0 | 467 | 1,565 | 14,611 | 586 | 0 | 0 | 455 | 0 | - | |
Week2 | Thu | 0 | 1,198 | (1,885) | 9,077 | 382 | 0 | 0 | 2,154 | 0 | - | |
Week2 | Wed | 0 | 0 | 0 | 2,153 | (862) | (30) | 0 | 0 | 0 | - | |
Week2 | Tue | 0 | 0 | 0 | 11,056 | 0 | 0 | 1,771 | (0) | 0 | - | |
Week2 | Total | 0 | 1,520 | 4,072 | 48,675 | 1,123 | (30) | 1,855 | 2,567 | 0 | - | |
Week3 | Mon | (599) | 820 | 4,225 | 14,638 | 1,460 | 0 | 1,018 | 1,124 | 0 | - | |
Week3 | Total | (599) | 820 | 4,225 | 14,638 | 1,460 | 0 | 1,018 | 1,124 | 0 | - | |
Total | (599) | 2,364 | 8,297 | 66,492 | 3,205 | (30) | 2,873 | 2,687 | 0 | - |
use aggr
sum(aggr(<presentExpression>,dimension1,dimension2,dimension3))
Prem,
Thanks for the replay.
But what if I am using 'value list' for SynDim within in the chart?
I can create the Dim from the script side to with "aggr" but is there any way I can solve this within the expression?