2 Replies Latest reply on Oct 14, 2016 5:05 AM by namrata patil

    addressing and partitioning in Tableau 10

    namrata patil

      Hello Team,

       

      Calculating percent from 1st index of each column to remaining.

      eg: 1st index value of column 1: 18 and following index values are 7, 13, 10, 7 so on.

      Then the percent calculation should be:  7/18, 13/18, 10/18, 7/18 ..

       

      Similary if 1st index of column 2: 73 and following index values are 46, 37, 31, 25 so on.

      The the percent calculation should be: 46/73, 37/73, 31/73, 25/73 ..

       

       

      I have used tableau calculation: sum(quantity)->percent from -> compute using : table(down then across) -> relative to : First.

       

      Is there any way to restart the quick table calculation relative to first for every column dimension?

       

       

      Kindly assist.

       

      Thanks.