10 Replies Latest reply on Aug 26, 2016 9:58 AM by David Li

    How to only see grand total on dashboard while utilizing a date filter

    Dustin Brickwood

      Hello,

       

      First post to the community!

       

      I have a question which is probably very easy to do but I cannot seem to figure it out. I have a list of sales totals that are filtered by a date drop down. When a user selects the range of dates I would like it to only show the grand total of sales for those dates selected in a single column. I know how to hide columns and create a grand total column but I do not how to tell Tableau to only show the grand totals for any dates selected within the dashboard. When I select my dates, for example Aug 1,2,3, the sales total table will show each day in its own column, I would like it so it just calculates the grand total of those dates.

       

      Any help would be greatly appreciated.