2 Replies Latest reply on Jul 13, 2017 12:58 PM by Alex Tudose

    dynamic percentage of running totals

    Alex Tudose

      Hi,

       

      Please see attachment. The data is structured by month for the most recent 24 months, by company/product with the corresponding sales.

       

      The task is to create a table showing the MAT share for each company, where MAT is the running total of the most recent 12 months - as shown in the workbook named 'MAT'. To get to this point, I used a running total table calculation combined with a date filter calculation. The problem is that I can't use 'percentage of row' to get the desired dynamic MAT share (as percentage of running totals) nor I can use an LOD expression i.e. FIXED. Seems I'm stuck, any help would be greatly appreciated!

       

      Tableau 10.3