5 Replies Latest reply on Apr 18, 2018 9:47 AM by Deepak Rai

    How to create subtotal for my each business unit categories: Sample Attached

    Helen Wang

      Hi all,

       

      Hope all is well.

      I have been trying to use size() but it reports problem:

       

      When I used the size functions to calculate subtotal at different levels, it reports problem.

       

      I am trying to create a Total line in my Tableau worksheet:

       

      Original version:

       

       

      Expected Version: ( I did it in Excel as I cannot achieve this in Tableau)

       

       

       

      Thank you very much for your time and patience!

       

      Best,

      Helen