Get sum between 2 special record that user select

[marjan_it]

Hi guys,

I have a table like below. I want to have two list box with status. start status and end status. when user select start status and end status we can show sum (duration) between these tow status for each message code. 

for example if we select  first status =2 and end status=5 we have two number. for messagecode=1 we have 100 and for messagecode=2 we have 70. what should I do?

MessageCode	Messagelog	status	duration
1	101	1	10
1	102	2	20
1	103	3	40
1	104	4	10
1	105	5	30
1	106	6	20
1	107	7	10
2	108	1	50
2	109	2	30
2	110	3	10
2	111	4	10
2	112	5	20
2	113	6	30
2	114	7	10

[Kushal_Chawda]

Can you give one example?

[marjan_it]

I sent you before a file test.qvw in previous comment.

[Kushal_Chawda]

I checked your QVW. I am able perform selection on Year and Dept and values are also changing. If you can give example on particular year and dept selection what will be the output?

[marjan_it]

look at these 2 image for a especial MessageId. before selecting year it shows data but after selecting year it does not show anything. For department is like this too.