on 2010 Sep 22 1:03 PM
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 !!
Thanks every one it's resolved ....
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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!!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Its hard to understand your problem. Can you repost your problem with sample data and expected output.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
66 | |
10 | |
10 | |
10 | |
10 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.