Result comparion between 2 dates

[#1]

Hi,

I have the following two tables Joined in the datamodel and I need to show the comparison between data for two date selections.

Lets say the dates are start and end date.

Requirement:  1.Report all the records that had passed on 01/06/2014 but failed on 22/06/2014

                         2. Find all records that have failed on 22/06/2014 but were not present on 01/06/2014

How can we achieve this?

[MK_QSL]

it's possible.. provide sample data in excel format please.

[#3]

Please find attached the xls

[MK_QSL · Accepted solution]

may be i don't understand your question properly.. you can try below

=COUNT({<Result = {'PASS'}, DATE = {'01/06/2014'},KEY = P({1<Result = {'FAIL'},DATE = {'22/06/2014'}>}KEY)>}KEY)

and

=COUNT({<Result = {'FAIL'}, DATE = {'22/06/2014'},KEY = E({1<DATE = {'01/06/2014'}>}KEY)>}KEY)

[#5]

That was brilliant mate Thanks a ton