Month Calculated Dimension

[#1]

Hi,

I have a table similar to this:

Site	Month	Year	Units
East Linton	Jan	13	0
East Linton	Feb	13	0
East Linton	Mar	13	17
East Linton	Apr	13	15

What I need to calculate is the Total No of Units - 32 and the  Month where the the first units were sold - Mar 13. I need to create a chart that will look as follows:

Site	Month of Purchase	Units Sold
East Linton	Mar 13	32

I have Site as a Dimesion. The calculation for units sold is, this works fine:

sum(Aggr(DISTINCT $(vUnitsSold),Site))

However I am sturggling to work out the Calculated Dimension to give me the Month where Units <> 0 and Month = Min(Month) where a value exists?

Any help appreciated.

Thanks,

Nikki

[Gysbert_Wassenaar · Accepted solution]

See attached example.

[#3]

It Works!

Thank You Gysbert!