7 Replies Latest reply on May 3, 2018 4:18 PM by Shinichiro Murakami

    Customize Grand Totals

    Victoria Wong

      Hello Tableau Community,

       

      This is my first post. I am trying to find a way to customize the row grand total. I have 2 metrics, sales and stock (balance). For Sales, I want to the grand total to sum the months; but for Stock, i want the ending balance to reflect the latest month. In the example attached, Stock would equal December (10,510); however, I have a set up a Date Parameter, so the End Date would vary. If this is not possible, the other option would be to show an empty cell.

       

      Any guidance would be greatly appreciated. Thank you!

       

      I am currently on Tableau 10.4.4