show the different key figures

[Former Member]

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

[Former Member · Accepted solution]

Hi Ping,

Have you solved your problem?

Best regards,

Eugene

[Former Member · Accepted solution]

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