on 07-16-2020 11:23 AM
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
User | Count |
---|---|
94 | |
11 | |
11 | |
10 | |
9 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.