I have searched the forum endlessly, but i couldn't find my solution.
I am trying to create a line-chart, with only one line( grouped lines or bars i what I have achieved already). And this line shall include the total Sales Sum of the top 3 customers.
Meaning: Chart shall have a X dimension which is date. The Y-dimension should be the total sum of Sales of the top 3 customers on this particular day.
Columns in the table are:
- MasterDate // Date of each day
- SendingPartner // Customer Name
- Sales // Amount of sales on this day
Can you help me with building an expression which works in a chart. I am able to calculate the sum already for a text box, but drilling this down always gives me by using the aggr function also the SendingPartner split. And I'd like to avoid this, because i the chart i only need one line.
thanks for your reply. I used the rank function already, but it throws back for each of the top 3 a single value. And this results in three lines in a line chart. I need only one single line with the cumulated sum of all top 3 customers.