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