5 Replies Latest reply on May 3, 2012 12:25 PM by Craig Hansen

    Tie a measure to a particular dimension

    Craig Hansen

      Hello!

       

      I have a cross tab similar to this:

       

      Hub ID#Inventory DescriptionQuantity
      HUB-100CUST-INV011000
      HUB-100CUST-INV02250
      HUB-101CUST-INV03100
      HUB-101CUST-INV04
      HUB-102CUST-INV05
      HUB-102CUST-INV06
      HUB-103CUST-INV07150
      HUB-103CUST-INV08500
      HUB-104CUST-INV09
      HUB-104CUST-INV10

       

      I want to tie the Quantity(measure) column to the Hub ID#(dimension) column so that I can display only Hub ID#'s that have zero quantity (IE: it would only show HUB-102 and HUB-104.) Using a filter on Quantity to show null/zero values will always show the empty inventory location in HUB-101. Help! Is there a filter type I'm missing or a calculation field I can create to omit Hub ID#'s with any amount of quantity?