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

    How to tableau

    Manish singh

      Hi

       

      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.

           

          Cheers.

          • 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.