Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I have a straight table with Period, Sum(Sales). I want to display the period with the maximum sales in a text box. If I use max(Aggr(sum(Sales),Period)) I get the maximum sales value so how can I get the period which that value belongs to?
Thank you
Hennie
Try this.
Only({<Sales={"$(=Max(Aggr(Sum(Sales),Period)))"}>}period)
Hi Manideep
Thank you it works! Can you please explain to me how the function works (how the function gets to the answer) and also the reason for the use of the $ sign?