5 Replies Latest reply on Jul 7, 2016 12:02 AM by Aiswarya Sundaram

    Want to customize sub-total

    Ashis Kumar Sau

      Hello,

      I have Region, country dimensions, and i have sales metric. I want to see , subtotal of sales per Region, instead of country.

       

      For example ,the last column is showing me the Region wise subtotal that is correct .

       

      I want to print this value only once per Region , instead of showing for all the country column.  The formula i have used to calculate the subtotal is

      WINDOW_SUM(SUM([Sales]))

      I have attached twbx file for your reference.