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