How to Modify a single cell of Dimension in WEBI Report

[Former Member]

Hi,

I created one WEBi Report by using 4 dimensions and 2 Measures.  In some of the rows i want to make the cell as blank.

For example:

Org      Plant       Dist Channel        Net Value        Qty

2000      P1               20                      4000            60

3000      P2               30                      5000            70

What i need :

Org          Plant       Dist Channel        Net Value        Qty

2000                               20                      4000            60

3000           P2               30                       5000            70

in plant i need to make the value in first row as blank. how can i do this?

[Former Member]

Hi,

You can Apply conditional formatting and hide the value by making the font colour as White.

Use =RowIndex()=0 in Conditional Formatting Rule.

Thanks,

Parthiban

[Former Member]

Hi Sudha,

You can use formula as below to acheive what you are trying to acheive, if you know the set of values which you want to replace with blank.

=If([Plant] InList("P1";"ABC");""';[Plant])

Provide more details if you have specific logic associated with where all to replace data with blanks.

Thanks

Mallik