Skip to Content
0
Former Member
Nov 10, 2011 at 03:18 PM

CY and LY in one cross tab

43 Views

Hi ,

In one of the reports I need to show both current year revenue and last year revenue month wise in one cross tab.

For this two dataproviders are built. one for current year revenue and other for last year revenue .

Can any one help me how to display both the revenue in the same cross tab with current year month values in the horizantal header.

Please find the cross tab structure to be in the report.

Jan `11 Feb `11 Mar `11 Apr `11

Current Year $100 $200 $300 $400

Last Year $75 $56 $23 $89

Data from Current Year Query

Month Revenue

Jan `10 $75

Feb `10 $56

Mar `10 $23

Apr `10 $89

Data from Last Year Query

Month Revenue

Jan `11 $100

Feb `11 $200

Mar `11 $300

Apr `11 $400