1 Reply Latest reply on Jun 5, 2016 6:48 AM by Yuriy Fal

    Require tabular report with Grand total followed by percent calculation

    Amit Punalekar

      Hello,

       

      I'm newbie to the community so I'm learning as I get along.

      I have created a tabular report in Tableau using a calculated member and summing data across the Site and  product line category which is working as expected. I was finally able to get the grand total from Analysis tab and everything seems to go well and I thought I'm almost done with the report. The final portion is to add percent calculation just below the Grand total line which I'm struggling to achieve this last piece of functionality.

       

      Below the Grand Total line I need  the following line which is percent calculation of  Grand Total with respect to Alpha total.  96324.86 / 217529.56  = 44.28% for Jan and so on. I prefer this to be part of the same workbook if possible.

       

      Alpha
        AWPUPD vs Floor
      44.28%35.89%36.50%

       

       

      Thanks

      Amit