I have a report wherein I have to restrict the zero values in the columns. The report is based on a SAP BW Bex query and the zero values come from a key figure. I cannot put the condition in the query filter since it doesnt allow me to pull the measure there.
If I try to put a report or a block level filter, the all the measures become #UNAVAILABLE. The report looks somewhat like the below:
Dim1| Dim2| Dim3| M1| M2| M3
A | B | C | #UNAV|#UNAV|#UNAV
M3 is the variable I need to put a filter on for supressing Zero. I have tried with the measure(key figure) and the underlying attribute(Formatted value). The result is the same. Please advise.
Thanks and regards,