

Creator III
2019-12-19
12:28 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Suppressing Null In Master Items
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,
RY
582 Views
0 Replies
