4 Replies Latest reply on Aug 6, 2015 8:55 AM by venkatesh.sharma

    need help on tableau text report

    Atul Ghadigaonkar

      I am creating a tableau report and facing some issue

       

      Can you please help me see the bellow

       

      Is this format is possible in tableau

       

      1. 1. Measures are SALES, PROFIT, MARKETING COST, MENUFACTURING COST
      2. The Dimensions are Subgroup
      3. Period1 ,Period2 And Change are calculated field by [Year Month]

       

      Basically my report should look like "Report format.xlsx"


      And my data structure are like

       

      Sub Group

      Year Month

      Sales

      PROFIT

      MARKETING COST

      MENUFACTURING COST

      EAST

      2014-01 Jan

      xxx

      xxx

      xxx

      xxx

      EAST

      2014-02 Feb

      xxx

      xxx

      xxx

      xxx

      EAST

      2014-03 Mar

      xxx

      xxx

      xxx

      xxx

      EAST

      2014-03 Apr

      xxx

      xxx

      xxx

      xxx

      WEST

      2014-01 Jan

      xxx

      xxx

      xxx

      xxx

      WEST

      2014-02 Feb

      xxx

      xxx

      xxx

      xxx

      WEST

      2014-03 Mar

      xxx

      xxx

      xxx

      xxx

      WEST

      2014-03 Apr

      xxx

      xxx

      xxx

      xxx

      SOUTH

      2014-01 Jan

      xxx

      xxx

      xxx

      xxx

      SOUTH

      2014-02 Feb

      xxx

      xxx

      xxx

      xxx

      SOUTH

      2014-03 Mar

      xxx

      xxx

      xxx

      xxx

      SOUTH

      2014-03 Apr

      xxx

      xxx

      xxx

      xxx

      NORTH

      2014-01 Jan

      xxx

      xxx

      xxx

      xxx

      NORTH

      2014-02 Feb

      xxx

      xxx

      xxx

      xxx

      NORTH

      2014-03 Mar

      xxx

      xxx

      xxx

      xxx

      NORTH

      2014-03 Apr

      xxx

      xxx

      xxx

      xxx