Need Help

[qv_testing]

HI Community,

I have one table like,    I have three fields EmpID, Status and TempDate..

I want to compare with two Months, like 2 variables StartMonth and EndMonth..

Suppose  if i am select May and June,  status wise i have to show data how many changed records.....

EmpID	Status	TempDate
123	InProgress	5/27/2015
11	Resolved	5/27/2015
679	Resolution Pending	5/27/2015
678	Opened	6/27/2015
123	Assigned Owner	6/27/2015
11	Resolution Pending	6/27/2015
11	Resolved	6/29/2015
13	InProgress	6/29/2015

Example:

See one particular case..

EmpID	Status	TempDate
123	InProgress	5/27/2015
123	Assigned Owner	6/27/2015

Here particular ID wise changed status InProgress to Assigmed Owner..

I want to show  like this......

[qv_testing]

PFA,

I have attached 5 months data...

[qv_testing]

Hi Jagan,

Have you Understand my scenario...

Let me explain again....

I have ID, Status and Date these are my fields...

Suppose i have created 2 variables.. these variables compare with status..

Suppose if i am select June and May..

In my June Month status Resolved, May Month status it has Changed..

Here one particular case..

See here Resolved June status and May status

Assigned Owner (This count 1)

Resolved (this Count 1)

Resolution Pending (This count 2)   Total count 4

Actually i have attached Images i.e hard coded for June and May month......

I want to compare Month to Month, if i am select Dec and Jan i want to compare based on selection..

Hope You understand.....

[qv_testing]

Hi Venkita,

Thanks for response..

I want to change based on selection....

I have all months data...