Get the right unit price to calculate with selection

[alex3049]

Hi,

I have to calculate a cost, where I want to use the UNIT PRICE of the minus selection of TIME made by user.

TIME	UNIT PRICE	QUANTITY	CUSTOMER	ART	COST (QUANTITY * UNIT PRICE)
202011	3	546	A	A1	1638
202101	3,84	550	A	A1	2112
202103	4	555	A	A1	2220
202102	5	4	X	A2	20
202103	6	12	X	A2	72

1/ If user select TIME between 202011 and 202103, I want to use the UNIT_PRICE 3 for ART A1 and the UNIT_PRICE 5 for ART A2, because it's the price of the minus periode of selection

TIME	UNIT PRICE	QUANTITY	CUSTOMER	ART	PRICE FOR COMPUTE	COST
202011	3	546	A	A1	3	1638
202101	3,84	550	A	A1	3	1650
202103	4	555	A	A1	3	1665
202102	5	4	X	A2	5	20
202103	6	12	X	A2	5	60

2/ If user select TIME between 202102 and 202103, I want to use the PRICE_PER_ART 3 for ART A1 and the PRICE_PER_ART 5 for ART A2, because it's the price of the minus periode of selection

TIME	UNIT PRICE	QUANTITY	CUSTOMER	ART	PRICE FOR COMPUTE	COST
202103	4	546	A	A1	4	2184
202102	5	4	X	A2	5	20
202103	6	12	X	A2	5	60

Finaly, In my app, I don't want to display the ART LEVEL, I just want to diplay customer, cost

1/

CUSTOMER	COST
A	4953
X	80

2/

CUSTOMER	COST
A	2184
X	80

How can I have retrieve in my set analysis, the UNIT_PRICE of the minus selection for every ART?

Thanks for the help

[dwforest]

Create a Master Calendar and then connect to your TIME field.

Selections made on the Master Calendar Year and Month fields would limit the output to only those within the selection