Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
May be this
FirstSortedValue(Day, Aggr(Sum(Sales), Day))
Excellent! Thank you Sunny