Quaterly Cut-Off date report

[ruudkamp]

Hi,

I need to allocate historical value’s to a quarterly cut-off date report. When an amount is changed,  I have record  with DateChanged and the new Amount . My Input data looks like:

EmployeeID	ExpenseType	DateChanged	Amount
A	Salary	01-01-16	500
A	Salary	15-04-16	550
A	Salary	01-01-17	575
A	Travel	01-01-16	10
A	Travel	15-05-16	0
A	Travel	01-01-17	15
B	Salary	01-02-16	390
B	Salary	01-01-17	410
B	Travel	01-02-16	17
B	Travel	01-01-17	19

The report I need is:  

EmployeeID	ExpenseType	01-01-16	01-04-16	01-07-16	01-10-16	01-01-17
A	Salary	500	500	550	550	575
A	Travel	10	10	-	-	15
B	Salary	-	390	390	390	410
B	Travel	-	17	17	17	19

Who can help me?

The Excel model is attached - Ruud Kamp

[Anil_Babu_Samineni]

In your data you don't have few dates which you are showing Data set. Does this true, If so then please help us the logic behind

[ruudkamp]

Hi,

I have attached the qvw model.

And the required output for employee A only Salary,(PDF)

thx a lot