cancel
Showing results for 
Search instead for 
Did you mean: 

Cross Tab reports

Former Member
0 Kudos
59

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 !!

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

Thanks every one it's resolved ....

Former Member
0 Kudos

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
0 Kudos

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
Contributor
0 Kudos

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