Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Today I have very simple case, I have table with only 3 columns (attach xlsx).
PARTNER | SCORING_CURR | SCORING_FWRD |
PARTNER_82 | 2 | 3 |
PARTNER_82 | 2 | 2 |
PARTNER_82 | 2 | 2 |
PARTNER_82 | 3 | 2 |
PARTNER_82 | 3 | 3 |
PARTNER_82 | 3 | 3 |
PARTNER_82 | 3 | 3 |
PARTNER_82 | 3 | 3 |
I need to create a pivot tables with % of partners quatities:
Any suggestions.
Try this:
=Count(PARTNER)/Count(TOTAL <SCORING_CURR>PARTNER)
you truly are a legend
I am glad I was able to help