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

Do not display the overall result for one KF

Hi,

Question is in the title, here is an explanation of what I want to get with a simple BEx query (without adding extra vba)

2 KF : KF1 and KF2

2 Caracteristics : let's say 0PLANT and 0CALMONTH

0CALMONTH is displayed in line, 0PLANT in column

overall result 1701 1709 1710

0calmonth KF1 KF2 KF2 KF2

01.2009 xxx xxx xxx xxx

02.2009 xxx xxx xxx xxx

03.2009 xxx xxx xxx xxx

Basically what I want is to KF1 only for the aggregation of all plants and I want to display KF2 for each plant

Do you think this is possible ?

For now I only succeed in getting

overall result 1701 1709 1710

0calmonth KF1 KF2 KF2 KF2 KF2

01.2009 xxx xxx xxx xxx

02.2009 xxx xxx xxx xxx

03.2009 xxx xxx xxx xxx

I checked the forum for a while and did not find the answer (zero suppress do not work on result)

Thanks for you help,

rgds,

Sebastien

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jan 27, 2010 at 05:22 AM

    Hi,

    I didnt get exactly for what you are looking for ,

    Chars : 0Plant, 0Calmonth....put these two in two new selections by creating a new structure in Rows

    KF: what ever the KFs you need put them in Columns in a structure,

    then enable the Cell Reference, now you can hide the KF results by cell wise and/or column wise however you need,

    Regards

    ReddY A

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 27, 2010 at 07:28 AM

    Hi Sebastian,

    Try This......FOr norma KF it works ,check for Aggregation KF.

    Choose the KF ,for which you want to Hide the Result.

    In the properties tab of the KF goto the Calculations--->.Calculate Result as Hide (last Option in the Selection).

    Execute the Report ,the Overall Result shud not be displayed i.e it shud be hidden.

    Rgds

    SVU123

    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.