Display data difference between 2 months

[#1]

Hi,

Problem with display the different data rows between 2 months

Description: I would like to create a table where I can show the change of the data between 2 months where the field Admin = 'yes'

Details:
I want to show only these data rows in the table where the Key field "Key" has changed to the previous month,
in my example, where are changes between 2011-Jan and 2011-Feb in the field "Key".

I have tried nearly every possibilities, set analysis with bookmarks, within script, but all without a solution.

I hope somebody could give me a solution for my problem?

Please use the attached .qvw file

Kind regards,

Herbert

[pover · Accepted solution]

Hi Herbert,

I think this is what you are looking for. Tell me if you have any questions.

Regards.

[#3]

Hello Karl,

I have looked at your solution, thank you very much, that is the solution what I need, and it can be used for the comparision in every month.

I have also tried it with set analysis before, but I failed, this is not my strength:-)

Thank you Karl.

Kind Regards,

Herbert

[#4]

Hi,

Karl Power , I have the ID's for example cd001 to cd007 . I want to give the From ID and To ID as parameters and display the rows from ID and To Id. how is it possbile, can you give me some idea.

Regards,

Ramesh