Characteristics in column

[Former Member]

Hi,

I need to have the following in BI7.0 where C1, C2 and C3 are characteristics K1, K2 are keyfigures. C3-material and K2-qty so that the qty for a particular material is displayed in the column. Also,I need to put K1 before C3.

C1 |C2 | K1 | C3

-

---

K2

I amnot able to add K1 before C3 and K2 after C3 in the column. Hence, I don't get the desired result.

How can I have one kefigure before the characteristics and another keyfigure after the characteristics in the column?

Thanks.

[former_member184494 · Accepted solution]

Have the report in this format

C1|C2|C3|K1|C3*

here C3 can be hidden and then have a formula variable with replacement path on C3 with characteristic value.

Edited by: Arun Varadarajan on May 29, 2009 8:29 PM

[Former Member · Accepted solution]

Thanks. Points assigned.

[Former Member]

It's worth to say that this trick only works for characteristics with type NUMC and for displaying their keys (not texts)