cancel
Showing results for 
Search instead for 
Did you mean: 

Percentaje Over Column Grand Total

ErickRuiz7
8 - Cloud Apps
8 - Cloud Apps

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.

ErickRuiz7_0-1740580884016.png

Regards,

 

4 REPLIES 4

HamzaJ
12 - Data Integration
12 - Data Integration

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
Community Team Leader
Community Team Leader

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.

David Raynor (DRay)

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
Community Team Leader
Community Team Leader

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

David Raynor (DRay)