3 Replies Latest reply on Jul 10, 2018 11:34 AM by Shinichiro Murakami

    Calculating TotalSum per dynamically calculated Ranks

    Sachidanand bommegowda

      Hi All,

       

      I am trying to make use of Tableau's Table calculations functions for a particular scenario. As attached in the pic below, this is my current situation.

       

      What i wanted to understand is,if i can get an output which looks like below

       

      All it does here is bin different ranks by insurers and then calculate the total premium under these ranks. I have taken InsD as an example. I am attaching my workbook over here. Please let me know on how to approach this interesting problem.

       

      Best Regards,

      Sachi