8 Replies Latest reply on Feb 18, 2016 12:53 PM by Patrick A Van Der Hyde

    Grand total not working properly.

    Anubhav Saxena

      Hi I have one scenario ..


      My data looks like this :




      When doing a count distinct of salesman data looks like this :




      But what I actually want is SUM([Sales])/TOTAL(COUNTD([Sales man])) i.e Sales per number of person working in that region.


      But when I apply this formula everything comes correct except sum of Grand total.


      I have referred to these blogs:



      Customizing Grand Totals – Part 1 | Drawing with Numbers


      They were not of much help.


      It will be great if someone suggests something.



      PFA tableau worksheet.