Skip to Content
author's profile photo Former Member
Former Member

Cross Tab reports

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Posted on Sep 22, 2010 at 03:17 PM

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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 22, 2010 at 03:46 PM

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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 29, 2010 at 08:18 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 25, 2011 at 07:00 AM

    Thanks every one it's resolved ....

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.