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!