1 Reply Latest reply on Sep 26, 2016 4:55 PM by diego.medrano

    How to consolidate Date Fields?

    irene.day

      Hi everyone,

       

      I'm new to tableau. I have a workbook showing sales analysis monthly. The result is something like below, and the user can choose the range of time period like last 3 months/previous month/last year etc.

      JanFebMar
      Apr
      Goal100200300400
      Revenue1040150400
      % achieved10%20%50%100%

       

      My question is, how do I consolidate the results to show a total at first then the user could have a "+" sign to drill down the data into each month?

      And the consolidate range should based on the date range the the user selected.