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:

       

      http://drawingwithnumbers.artisart.org/customizing-grand-totals-part-2/

      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.

       

      Thanks

      Anubhav