Percentaje Over Column Grand Total

[ErickRuiz7]

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 grand total each FLM has, but I would like to check if there is anyway to get the % over the grand total. 

Example: The first row FLM sold a total of 109 products, but out of those 109 products, 26 are 1p. I would like to perform a division 26/109 = 23.85% out of all sales made by that FLM are 1p packages. 

This is what Im looking for, Im looking to divede each FLM sales per packege over their own grand total.

Regards,

[HamzaJ]

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

[DRay]

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.

[ErickRuiz7]

Thank you very much for kindly following up, I stopped that project until half March, I will try the solution in a few weeks. I appreciate the kindness

[DRay]

Thank you for the update. I would love to hear how it goes!