Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello using the formula im finally got the top 10 values in pivot table
SUM({<PARTNER= {"=Rank(SUM([Quantité Facturé]),4)<=10"}>}[Quantité Facturé])
im looking to show another column for "percentage of total" like this
PARTNER | TOP 10 | |
ENVASES | 2 069 064,00 | 3% |
EVIOSYS | 34 604 518,00 | 44% |
EXPRIM | 1 136 060,00 | 1% |
GHARB | 880 868,00 | 1% |
IMPRIMEPEL | 4 791 808,85 | 6% |
MASSI | 17 488 452,00 | 22% |
TRIVIUM P | 8 438 174,25 | 11% |
TRIVIUM B | 1 504 224,00 | 2% |
TRIVIUM C | 6 766 020,00 | 9% |
TRIVIUM D | 1 821 924,00 | 2% |
Total | 79 501 113,10 | 100% |
I think it would just be:
Column(1) / SUM({<PARTNER= {"=Rank(SUM([Quantité Facturé]),4)<=10"}>} TOTAL [Quantité Facturé])
-Rob
I think it would just be:
Column(1) / SUM({<PARTNER= {"=Rank(SUM([Quantité Facturé]),4)<=10"}>} TOTAL [Quantité Facturé])
-Rob
Thanks Bob that worked