Percentaje Over Column Grand Total
Hello team, I have the following Pivot Table built on Sisense, The FLM rows are the names of our managers, the columns 1p, 2p, 3p, 4p are the combo packages sold to our clients, Im getting the gran...
Forum Discussion
Hey ErickRuiz7 ,
Unlike Excel, you cannot change the way the grand total is calculated/shown unless you also change the way the regular (1p-4p) are shown if I am not mistaken.
What you can do this create a seperate formula/measure for each P and a formula for the grand total (column). After that you can enable grand total (row) on a manager level.
So in Excel it would look like:
Row: Managers
Measure : Combo packs
Columns: xP
In Sisense it would look like:
Row: Managers
Measure:
- sum([Combo Packs],[xP]) --> filter xP on 1p
- sum([Combo Packs],[xP]) --> filter xP on 2p
- sum([Combo Packs],[xP]) --> filter xP on 3p
- sum([Combo Packs],[xP]) --> filter xP on 4p
- sum([Combo Packs]) --> 3 dots > Quick Functions > contribution
Enable Grand total on the managers field
Hamza
