Pick a Day with lowest sales in a text box

[maxsheva]

HI,

I need to pick a Day with lowest sales and present it as value in a text box.

LOAD * Inline [

Day, Store, Product, Sales

1, S1, P1, 100

1, S1, P2, 150

1, S2, P1, 200

1, S2, P2, 500

1, S3, P1, 400

1, S3, P2, 200

2, S1, P1, 500

2, S1, P2, 400

2, S2, P1, 200

2, S2, P2, 100

2, S3, P1, 200

2, S3, P2, 300

];

How can I use this Min function in Set analysis to get Day from Only() ?

Min(Aggr(sum(Sales),Day))

Any ideas would be greatly appreciated.

[sunny_talwar · Accepted solution]

May be this

FirstSortedValue(Day, Aggr(Sum(Sales), Day))

[maxsheva]

Excellent! Thank you Sunny