How can I hide the unit/currencies row in tables?

[Former Member]

I have constructed a query within BI7 and utilized scaling factors for some of the data. The top row of the table is as below:

http://img256.imageshack.us/img256/1972/unitcurrencygr2.jpg

I need to hide the scaling factor and unit row (shown in the red box). There was an option under "Query Properties" to uncheck "Display Scaling Factors for Key Figures" (under the "Display" tab) but this doesn't seem to make any difference?

Your help is much appreciated

[Former Member · Accepted solution]

Do you want to hide the complete row (shown in Red) or Just the scaling factor and Units?

If its secnd one what you need, then scaling factor should be possible the way you tried. And for hiding Units, somewhere in formula editor you have the option of

NDIV() ...means no dimentions. Please try this.

Regards

Pankaj

[Former Member · Accepted solution]

Thanks Pankaj - it has all worked out btw! there was an option in WAD to view/hide the scaling factor in Analysis tables - this proved to be key to displaying in the form we wanted