Multiple Key figure in a single column of a query

[Former Member]

Hi,

Is it possible to use muliple key figure like Amount and Qty field together in a column of a query?

Please advise,

Best Regards,

UR

[Former Member]

Hi,

You will be able to do it with the help of cell definitions.

Say,you have a structure in Rows :

A

B

For A ..in corresponding column cell,use cell definition with KF1

For B.....in corresponding column cell,use cell definition with KF2

this way,you will be able to see both in one column

I m not sure how much it is relavant to your requirement.But this is one way of gettin it

[Former Member]

You can always write JavaScript to modify the BW generated table the way you want. Here you can concatenate the innerText of required columns and hide one of them.

Remember to test with every possible drill down because sometimes the rowspans more than 1 create problems.

Abhijeet

[Former Member]

If you talking about column section in query designer, ofcourse you can. When you will drag both keyfigures in column section, they will appear as 2 different columns per row in report.

If you talking about combining 2 key figures to display in 1 column, I am not sure how it will serve purpose anyways. You may be able to do calculation but not sure if key figures can be concatenated. If they were characteristics, then it was possible at backend.

Abhijit