2 Replies Latest reply on Aug 22, 2016 9:32 AM by Anu Rekha

    Table Calculation along year

    Anu Rekha

      Hello All

       

      Greetings! Hope you all are doing well.

       

      I am working on a tableau calculation. Not able to get the total for the( Highsales+Lowsales)  on a year basis

       

      I cannot use LOD calculations because of special requirement constraints.

       

      Please have a look in to link below.

       

      Tableau Public

       

      I want the bottom row to be be total of first row for each year (98+38) and (68+133).

      Now I am getting wrongly as 337(i.e sum of both years), I want total for each year.

       

      i.e. 2nd row should look like,

       

      136 136 201 201

       

      Please help if you have come across similar situations before. Thanks in advance.

       

      Thanks

      Anu