2 Replies Latest reply on Sep 28, 2018 9:07 AM by Jeffrey Farris

    Column Grand Totals by Year

    Jeffrey Farris

      I need to display the column grand total for each year to evaluate changes from year to year. This report will be updated with new weekly data to help senior management compare performance this year versus last year. It uses a Friday to Thursday week.

       

      I tried https://kb.tableau.com/articles/HowTo/display-grand-totals-column-for-each-nested-dimension-member but am having trouble because it is a date. I also tried converting the date to a string to use this solution but am not familiar enough with string functions extract the year to use in the formulas suggested above.

       

      Workbook attached. Tableau Desktop 2018.2.0.