0 Replies Latest reply: Nov 28, 2012 11:47 AM by kathyhciti RSS

    Custom Others or Total calculation in straight table

      Is there a way to customize the Others or Total aggregation in a straight table?

       

      What I want: max(.15 - TotalSales / TotalSectorSales, 0) * TotalSectorSales where Total Sales = Sum_{c in companies} (Sales_c) and the same for sector sales

       

      QV seems to do the aggregation this way:

       

      Sum_{c in companies} ( max(.15 - Sales_c / SectorSales_c, 0) * SectorSales_c)

       

       

      Your help is greatly appreciated.