4 Replies Latest reply on Oct 6, 2016 2:34 AM by Norbert Maijoor

    Grand total that only uses filtered data

    Henrietta Bathurst

      Hi all,

      I'm looking to create a grand total that only shows the total of filtered data - I have looked on the forum for previous posts and been sent here (Customizing Grand Totals – Part 3 | Drawing with Numbers ) which seems very complicated and involving multiple tables (unless I am interpreting it wrong) so hoping there's an easier way, possibly with the new update (Tableau 10) that doesn't involve all the joins (as don't think that works with the data I am working with)?

      The filter I am using for my data is a Top N with a parameter so would ideally like the grand total to update whenever the parameter value is changed if possible.

       

      Thanks in advance!