How can I hide the unit/currencies row in tables?
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:
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
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.