transformMax

Hi,

Looks like there is no transformMin function similar to transformMax function.

How do I get the minimum sales number for a store among a group of stores (i.e in a cluster)

For eg, if there is are 5 stores in 1st cluster, 3 stores in 2nd cluster. The 5 stores in 1st cluster have sales such as 10,20,30,40,50 and the 3 stores in 2nd cluster have sales such as 100,200,110.

Here the measure displaying minimum sales of a store within a cluster should display 10 for cluster 1 and 100 for cluster 2.

I am able to find the max sales by using transformMax.

We even tried multiplying the sales with -1 to get -10,-20,-30,-40,-50. And then used transformMax to get -10 and multiplied again with -1 to get the value 10.