This content has been marked as final. Show 2 replies
I have a table similar to this:
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:
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.