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

show the different key figures

Hi,

Can we define a query, and show the different key figures, base on the different value of the characteristic?

Let's say, in the query, it contains a characteristic called "store", and if the store = A1,i want to only show key figure K1, K2, and a formular =K3/K2;

and if store = A2,then i want to show key figure K1,K2,and a formular = K4/K2; otherwise(for other store <>A1, or A2), i want to only show K1, K2 and a formular =K1/K2.

Is it a way fo rme to do that, pls advice.

Thank you,

Ping

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Sep 26, 2005 at 08:49 AM

    Hi Ping,

    Have you solved your problem?

    Best regards,

    Eugene

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Eugene,

      Sorry for my late reply.

      I just got teh chance today to do the testing. your suggest did help me solve the problem!! Thank you very much,and I appreciate your time and effort.

      I have reward the mark to this.

      Cheers,

      Ping

  • author's profile photo Former Member
    Former Member
    Posted on Sep 21, 2005 at 05:30 AM

    Hi,

    It is pssible by the combination of Logical expression in the formula and formula variable with replacement path .Just yesterday or day before yesterday we have discussed similar issue in this forum .Take a look on it.

    The link to the discussion is :

    conditional-display

    With rgds,

    Anil Kumar Sharma .P

    Message was edited by: Anil Kumar Sharma

    Add a comment
    10|10000 characters needed characters exceeded

    • Ok, Ping.

      Here is a step-by-step solution.

      In BEx Query Designer. I omit here what is placed in the rows (at least store, I assume). Working with columns.

      I see that you have no problems with restriction KF by T1…T4. And I will not stop at this moment, just continue (after creation of 4 selections restricted by time).

      - Place cursor on a K1 selection, right click – Edit (there you should see your Sales KF, restricted by T1), drag from the left panel and drop in the right one your STORE char. Right click on this char – Restrict. In the new “Selection for …” window in the left panel should be chosen ‘Fixed Values’ tab. Select in the left panel all the values, right click on an arrow – transfer all of them into the right panel. Find there your S0034 store, right click on it – Exclude from Selection. Do the same for S0035.

      - DO nothing with K2 (there you should see your Sales KF, restricted by T2).

      - Place cursor on a K3 selection, right click – Edit (there you should see your Sales KF, restricted by T3), drag from the left panel and drop in the right one your STORE char. Right click on this char – Restrict. In the new “Selection for …” window in the left panel should be chosen ‘Fixed Values’ tab. Select in the left panel your S0034 store, right click on an arrow – transfer it to the right panel.

      - Place cursor on a K4 selection, right click – Edit (there you should see your Sales KF, restricted by T4), drag from the left panel and drop in the right one your STORE char. Right click on this char – Restrict. In the new “Selection for …” window in the left panel should be chosen ‘Fixed Values’ tab. Select in the left panel your S0035 store, right click on an arrow – transfer it to the right panel.

      - Right click on a structure – new formula. Give it a name K5. Place into formula window K1 + K3 + K4.

      - Right click on a structure – new formula. Give it a name Percentage. Place into formula window K4 / K2 * 100.

      Hope now it’s clear and your problem is going to be solved.

      Best regards,

      Eugene

      Message was edited by: Eugene Khusainov

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.