4 Replies Latest reply on Nov 2, 2016 7:11 PM by Mike Loveless

    Filter by Table Calculation, but show the other measures.

    Mike Loveless

      Hi all,


      I'm attaching a sample replicating what I'm attempting to do.  I had a table calc showing the difference between one month to the next.  I turned this table calc into a calculated field.  I then want to only look at the results that have negative values for the difference, but I still want to see the total Sum of Sales for all the months so I can see all the sales that are resulting in the negative change.  Currently it is hiding the results for the totals based on the filter of the table calc.  I'm hoping I'm missing something simple as this seems like it should be easy to accomplish.  Any thoughts are appreciated.