1 Reply Latest reply on May 6, 2013 10:28 AM by Geoffrey Petit

    How do I look at aggregated sales data by week, month, quarter as columns of a single row?

    Salman Paracha

      Our business owners will like to review our sales data in the following form.


               Week 1      Week 2     Week 3     Janurary     February     Q1      Q2     MTD      QTD      YTD



      I don't want to create three or four separate worksheets and then export them to excel.


      I have created calculated fields for MTD, QTD and YTD, but I don't know how I would combine the

      weekly, monthly and quarterly sales data in a single row.


      I am using Tableau 8.0 and I am connecting live to an Oracle database.