Display currency in same column as key figure in Analysis for Office

[martin_chambers]

Hi,

We are using BW powered by HANA 7.5 SP 05 and Analysis for Office 2.4.

I want to display the currency in the same column as the key figure.

In the Eclipse query designer I have one characteristic in a row and one key figure in a column. I have 3 data records, two with currency = EUR and one with currency = GBP.

When both key figure values are 0, Analysis for Office Show two lines of data, one with EUR and one with GBP with the currency displayed in the same column next to the key figure. This is just what I want.

When the key figure for Euro is Changed to 10 and the GBP value remains 0 something strange happens.

The currency EUR is displayed in the column header.

Does anyone know how to prevent this display change. Any help will be appreciated.

[former_member283567]

Thank you Martin for your help.
I was looking for this setting in the Design Panel, but couldn't find it there.
Right mouse click on the cell in the Analysis for Office output did the trick for me. I was not aware of an additional setting option there.
I also tried "Display Scaling Factors for Key Figures" in the query design, but that has no effect in the Analysis for Office output as you also found out.