Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I think I need to use it, but I not sure how.
I did an example attached, I would like add the column "Need" it's just the Total by Country and Month.
I would like have this graph.
Country | Month | Product | A | A | B | B | Total |
Metric | Need | Metric | Need | ||||
canada | 01 | 1 | 23 | 32 | 9 | 32 | 32 |
canada | 02 | 2 | 6 | 18 | 12 | 18 | 18 |
france | 01 | 1 | 1 | 9 | 8 | 9 | 9 |
france | 02 | 2 | 5 | 16 | 11 | 16 | 16 |
usa | 01 | 1 | 4 | 14 | 10 | 14 | 14 |
usa | 02 | 2 | 7 | 20 | 13 | 20 | 20 |
I tried many formula...Could you help me?
Thanks.
I hope the attached file helps!
Hi,
Thanks for your answer!
but in fact I need to display the total in each column.
Eva
Eva,
Try this one. I added a new chart called 'Country/Month Total - 2' that displays the total (need) after each product.
thanks,
It's working in the example thanks. But I cannot multiply the number of metrics. I Have maybe 1 000 products .
I tried that : =aggr(Sum(Metric),Country,Month)
It's working for the first column but I cannot replicate for all of them.
Eva
= aggr(NODISTINCT Sum (Metric), Country, Month) works
Can you post your sample using the formula above so I can understand the solution?
Thank you!
Sure , thanks for your help!!!
Thanks Ava!
I’m glad someone was able to help you with your issue.