Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

New to Microstrategy, rows disappears when column value 0

New to Microstrategy, rows disappears when column value 0

New to Microstrategy, rows disappears when column value 0

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.

RE: New to Microstrategy, rows disappears when column value 0

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close