Sum quantity

[patrou38]

Hello,

I have a table in which there are a quantity of equipment by week (February weeks in my example).

in another table I would like to have the sum of qty by month.  I don't find the expression, the aggr ????

I expect that I'm enough clear.

than you for your help.

Patrick

[patrou38]

Enclosed my excel file used as calendar.

thank you again for your precious help.

Patrick

[sunny_talwar · Accepted solution]

Oh... I see that you are doing a Distinct count... I am not sure why you need a DISTINCT... but if you need that... may be try this

Sum({<Facility = {'$(vFacility)'}, ModelFamily = {'$(vModelFamily)'}>} Aggr(Sum(DISTINCT {<Facility = {'$(vFacility)'}, ModelFamily = {'$(vModelFamily)'}>} [TC inventory]), Year_Week, Year_month))

[patrou38]

guys,

I want to thank you very very much for your prompt and precious help... it's really appreciate.

have a good rest of the day

best regards,

Patrick