New to Microstrategy, rows disappears when column value 0

[lithium78]

We just hopped on board the Microstrategy bandwagon... during our initial report development when my column has a value of 0 the entire row is not displayed (instead of just showing a 0 for that particular row)

For example, we have a list of inventory locations on the row level. For our columns I'm using a total count of our total inventory by location, then I have filtered metrics to display the inventory by location based on multiple aging criteria (0-5 days, 6-15, 16-30, etc)

When I just have the total column everything is fine, but each additional filtered column causes rows to disappear if the filtered value is not within that row. (so if there are no items in the 0-5 days category the entire row is gone even though there is value in the total inventory column.

I've been playing with this all morning and I can't figure out the solution. Any suggestions will be greatly appreciated.

 

[AnaFlorTech]

have you tried in the report, data menu, report data options?
You have a null values tab where you can choose to appear 0.