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

want to Reduce the output of report?

I want to create a report. where i have Year in rows and month in columns with sales value.

If i select year 2009 to 2011 three record will. but in column for each year 12 column will come means 36 column for

sales value.

I want to see that in 12 columns. Like i want to see Jan one colum not three column like Jan,2009, jan,2010, Jan,2011.

How can i achive this thing. I already check with structures its possible with it. But is there any other function of Work around

for this available.

Regards

Malik

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Sep 12, 2011 at 07:03 AM

    Hi,

    Try Creating a Calyear range variable in the Filter section.

    Assign 0calyear to the KF. Check whether it works....?

    Regards,

    Suman

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 13, 2011 at 06:36 AM

    Use 0FISCYEAR in rows and 0FISCPER3 in columns. Currently, you are using 0FISCPER which is not correct and shows 36 columns.

    Hope it helps,

    Christian

    Edited by: Christian Röttgers on Sep 13, 2011 8:36 AM

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 13, 2011 at 11:49 AM

    Hi,

    Just you need to add variable on 0FISCYEAR or 0FISCPER.Add selection range variable and use it in query keyfigure.

    Thanks and regards

    Kiran

    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.