Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a line chart with month as dimension
i have monthly wise five year of data including current year.
requirement are:
1. One line as Current year sales data
2. And another line as year which has max sales.
You can simplify the set expression a bit using Rank() function:
=Sum({<Year = {"=Rank(Sum(Sales))=1"}>}Sales)
And if the OP wants to find the year with max monthly sales:
=Sum({<Year = p({<MonthYear = {"=Rank(Sum(Sales))=1"}>}) >} Sales)
Attached the modified version of Sunny's sample
Max sales total on a given year or max sales on a month?
Looking for something like this?
You can simplify the set expression a bit using Rank() function:
=Sum({<Year = {"=Rank(Sum(Sales))=1"}>}Sales)
And if the OP wants to find the year with max monthly sales:
=Sum({<Year = p({<MonthYear = {"=Rank(Sum(Sales))=1"}>}) >} Sales)
Attached the modified version of Sunny's sample
Hi swuehl thank you so much ...:).
So what were you looking for? The first solution or the second one. Just curious
actually i have used the expression given by SWUEHL .. i haven't open the example given by you... because i am using personal edition .