Suppressing Null In Master Items

rohitians — Sat, 16 Nov 2024 19:25:22 GMT

Hi Team,

I have two Master Items one in Dimension i.e If(City='Mumbai',City) so basically I want to create a master Item name Mumbai.

One Master Item in measures i.e Sum(Sales).

When i make a report i will get null values in the report like Mumbai --- Sales 200 but rest will go in null..

I want to suppress these null values ..

In a report we can do can we do it on the fly to suppress null.. so that when user uses these master items then there is no null value in dimesion..

Now this is an example the Measure will remain same but the Dimension will change..

Please help.

Thanks,

topic Suppressing Null In Master Items in App Development