How to display formula expressions depending on dimension values?

[hugmarcel]

Hi

I have a pivot table with 2 expressions a & b, lets say a=sum(1) and b=sum(2).

Dimension "x" takes 5 values 1, 2, 3, 4, 5.

I want to display expression a for dimension values 1, 2, 4, and expression b for dimension values 1, 2, 3, 5.

How can I do this?

Thx - Marcel

[#2 · Accepted solution]

Hello,

I think I could manage your problem, see the example in attach.

It is not good from performance reasons, but it works.

I wish it helps.

Nik.

[hugmarcel]

a nice solution, i like the pick-method.

thx - marcel

[MK_QSL]

Good Trick !!!

But as you told, performance wise not good and also it's difficult to make it dynamic. i.e. Bigger DataBase...

But still for this post,, good one..