1 Reply Latest reply on Mar 23, 2017 5:39 AM by Damien Minter

    Crosstabs with columns for Day / Week / Month / Qtr / Year

    Damien Minter

      I need to create a crosstab in Tableau which shows Day / Week / Month / Qtr / Year to date cumulative to the date in the filter. My data has a total column for values and another for dates and I will will then split the data by trader like below. I am guessing I need to create a calculated field but no idea of the syntax to get this result. I have been messing around with this for a couple days and haven't been able to work it out or come across any examples of this. I am trying to do a proof of concept for work, so am using Tableau public at home to do this, so would appreciate if answers could be shares in screen or links to the workbooks uploaded onto the tableau public site as I am not able to open workbooks created in licensed versions. (I have attached my two .csv files which I am using to test this out).

       

       

      Trader
      DayWeekMonthQTDYTD
      Jill1001000150025006000
      Jim50500200023004000
      Gary80100300035004050