Need Common Field values from a field for different periods by a single click or flagging.

[#1]

Dear all,

There is a requirement in Dynamic report with 2 Periods for Comparison where the scenario is:

1. Two periods available for selection-

Period1: 2 Calendars (vFromDate1 , vToDate1) ex. (01/01/2013, 15/01/2013)

Period2: 2 Calendars (vFromDate2 , vToDate2) ex. (01/01/2014, 15/01/2014)

2. For a Dimension two Expressions will be visible for ex. Branch  wise Sales1 for Period1 & Sales2 for Period2.

3. Any Measure and any Dimension can be selected.

4. Retailer Code is a field in the data model on which common field values are required.

Now the requirement is to show ex. Branch wise Sales1 & Sales2(Measure) where there are Retailer Codes common in both the Periods on a single click like button or a flag.

Ex. in Branch A if 10 Retailer Codes have there Sales in Period1(01/01/2013 to 15/01/2013) & Period2(01/01/2014, 15/01/2014) and from which 5 Retailer Codes are common in both the periods then after flag selection or a button click 5 common Retailer Code's Sales should be visible in Sales1 & Sales2 for Branch A.

Your help will be appreciated.

Thanks & Regards

Apurva