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 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,
ErickRuiz7
Posted 1 year ago·Last reply 1 year ago
4 comments
DRay
·1 year agoHello 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
OP1 year agoThank 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
·1 year agoThank you for the update. I would love to hear how it goes!
Hamza Jap-Tjong
·1 year agoHey 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:
Enable Grand total on the managers field
Hamza