We have a requirement in Web Intelligence report to show last 2 years record for comparison of sales revenue (cross tab). We have single query which brings 2 years of data along with sales details.
DATA SOURCE: (columns look alike - sample)
All columns like quarter/month name can be matched but weekend date will be different for each year. We have used context operator to include them in same block but only managed to achieve different results of not wanted (see below).
I understand that this can be achieved using context operators but not sure where it is being missed. Can anyone suggest other options.
We use SAP Business Objects 4.0 SP10 and Oracle as database.