2 Replies Latest reply on Aug 9, 2018 1:52 AM by Andrew Watson

    How to tableau

    Manish singh



      PFB the screen shot


      Now I want to subtract column 9 - grand tot column how should I do it


        • 1. Re: How to tableau
          Paulo Dantas

          Hi Manish,


          could you please provide a .twbx and give more explanation about what you are trying to do.



          • 2. Re: How to tableau
            Andrew Watson

            Without providing any data a guess is required to solve this. Your Grand Total is the maximum period per page. You could do that using a FIXED calc (and perhaps other ways but I don't know the construct of your data) such as {FIXED [Page],[Period]:MAX([Value])}. Take the MAX of that value, it should be the same as your Grand Total.


            Next you want to take the value of Period 9. IF [Period] = 9 THEN [Value] END


            Then you would use these new field, correctly aggregated, which depends on your data to something similar to:


            MAX(IF [Period] = 9 THEN [Value] END) - MAX({FIXED [Page],[Period]:MAX([Value])})


            To reiterate, multiple assumptions have been made about the construct of your data so the above may not work.