Hello
i have a data base with 3 fields: customer, date, week, and revenue.
in my webi report, i have only the week.
i want to show for each week the sum of the minimum revenue for all customers/
Example:
week 1:
Customer Date revenue
A 01.01.2020 100
A 02.01.2020 120
A 03.01.2020 300
B 02.01.2020 130
B 03.01.2020 190
B 04.01.2020 220
So the result i want for this week is = 100+130 = 230.
How can i get it?
Best,
Yuval