Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want this pivot table but I don't know how to build the last formula, as "sum(Qt) / sum(TOTAL)". How do I do?
Store | Product | Qt | % |
---|---|---|---|
A | X | 2 | 50% |
A | Z | 2 | 50% |
A | Total | 4 | 100% |
B | X | 2 | 29% |
B | Z | 5 | 71% |
B | Total | 7 | 100% |
Try this:
Sum(Qt) / Sum(TOTAL Qt)
Yeh, we already tried it, but the value in percentage appears as TOTAL of sum of stores, for example, in the table, to the first line appears as 18% (2/11) and not 50% (2/4).
Any other idea?
Aha, then you want this:
Sum(Qt) / Sum(TOTAL<Store> Qt)