on 06-11-2006 8:50 PM
I have a bex report with the characteristic as <b>product</b> and key figures as <b>plan, actuals</b>. i have created <b>variance</b> using a formulae. I have created an exception for <b>variance</b> with positive values given green colour, negative value given red colours, and 0 as yellow colour, I want to have the report in such a way that the exception colours for variance apply to the actual and i do not have variance coloumn in the final report
if i have understood u r requirement correctly,
Hide 'Variance' column.
go to Properties of 'Variance' -->Set Hide to 'always hide'.
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
You can achieve this in a workbook. I am trying out some other logic in BEx, will get back to you if succeeded.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.