13 Replies Latest reply on Dec 4, 2018 10:56 AM by Yuriy Fal

    Grand Total sums up all data for Lookup Filter

    Karthik Seshachari

      Hi Everyone,

       

      I'm a Tableau Newbie and would really appreciate your help. I have a Lookup filter lookup(min(([Date])),0) that preserves % difference calculation for the view.

      However, when I bring in Grand Total for Rows, it ignores the filter and shows data for all the months. I'd like the total of the first row to show up as 256+574+406 = 1,236

      Also, when selecting "Apply to Totals" on the lookup filter makes the "Grand Total" blank.

      Any tips or techniques that can help resolve this issue?