Cross Tab reports

[Former Member]

Hi All,

I want to create a Cross tab report in that report have two measure objects and two dimention objects(sate, Year)

sate dimention object will comes in Rows section and year dimention object will comes in column section ,in that year has current year and previous year data . current will dispaly one measure object and previous year will display in another measure object is it possible to creat the report

could you please any buddy will help me the same.

Thanks in Advanced !!

[Former Member]

Thanks every one it's resolved ....

[Former Member]

I am assuming that you have two measurs. Measure 1 holds Current Data, Measure 2 holds previous Year's.

Create a formula

if(Year(objectName)=Year(Date);Measure1;Measure2)

use this formula in the crosstab.

[Former Member]

Can you name 2 measure objects??

Or

Apply Break on [Year] object and drag and drop first measure object into Current/Prev year and do follow for second.

Thank You!!

[former_member207342]

Its hard to understand your problem. Can you repost your problem with sample data and expected output.