set analysis

[#1]

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.

[mphekin12]

I hope the attached file helps!

[#3]

Hi,

Thanks for your answer!

but in fact I need to display  the total in each column.

Eva

[mphekin12]

Eva,

Try this one.  I added a new chart called 'Country/Month Total - 2' that displays the total (need) after each product.

[#5]

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

[#6 · Accepted solution]

= aggr(NODISTINCT Sum (Metric), Country, Month) works

[mphekin12]

Can you post your sample using the formula above so I can understand the solution?

Thank you!

[#8]

Sure , thanks for your help!!!

[mphekin12]

Thanks Ava!

I’m glad someone was able to help you with your issue.