Percentaje Over Column Grand Total

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:

1. sum([Combo Packs],[xP]) --> filter xP on 1p
2. sum([Combo Packs],[xP]) --> filter xP on 2p
3. sum([Combo Packs],[xP]) --> filter xP on 3p
4. sum([Combo Packs],[xP]) --> filter xP on 4p
5. sum([Combo Packs]) --> 3 dots > Quick Functions > contribution

Enable Grand total on the managers field

Hamza

Hello ErickRuiz7,

I’m following up to see if the solution offered by HamzaJ worked for you.

If so, please click the 'Accept as Solution' button on the appropriate post. That way other users with the same questions can find the answer. If not, please let us know so that we can continue to help.

Thank you.