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 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?
Retrieving data ...