Skip to Content
0
Jul 16, 2020 at 10:23 AM

WEBI sum the minimum values

28 Views

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