3 Replies Latest reply on Apr 8, 2013 3:06 PM by Karl Jensen

    Show All Values

    Karl Jensen

      I have a filter that limits the results on a worksheet, the thing I would like is to show ALL values of the demension, even if the data is limited by the filter.  The measures, would show null (or zero).  I can understand logically how difficult this would be, but I am hoping it is possible.  I could build it into the query so that every value in the demension exists for every possible filter, but I would rather not due to the complexity of the query.


      Sorry, I should say that the "filter" is really an action, so "all values in database" is already selected. 


      Attached is a sample of what I am trying to do.  I have the System numbers, another sheet that has Facility numbers and then another one that has Provider Totals.  I need the values of the supplies to line up so that it is easier for the user to read. 


      Thoughts?  Thanks