2 Replies Latest reply on Aug 1, 2016 6:44 AM by Elías Santos

    How do I use a grand total in a calculation.

    Scott Heidenreich



      I'm new to Tableau.  I've looked for an answer in the Help documentation and by searching this forum to no avail. I have a table that has calculated the backlog that remains. (see below).


      The backlog started at 1152 and is now down to 174.  I would like to have a calculation of 1152-the grand total in the bottom right corner of the table that updates as the backlog changes each week.

      I would also like to have a "Percent Resolved" calculation that updates each week as the backlog is reduced.


      I have a perfect place on the Dashboard I would like to put those two numbers (see below).  Any help would be appreciated.