2 Replies Latest reply: Sep 4, 2017 5:16 PM by Claudio Bueno RSS

    Sum of product in pivot

    Claudio Bueno

      Hi guys,

       

      I know there are lots of similar questions to this but couldnt find any that suited me.

      I'm trying to get the sum of products from a pivot table (second table) rather the sum of the totals (first table).

       

      My expession is

      =Sum({<Tipo = {"STD"},Q=,[Mês]=,Valor = {"HRS"},Ano={$(=Getfieldselections(Ano))}>} Montante)*

      (Sum({<Tipo = {"ACT"},Q=, Valor = {"HRS"}>} Montante)-Sum({$<Tipo={$(=GetFieldSelections(Tipo))},Valor = {"HRS"},Q=>} Montante))

       

      Any help? Thanks a lot!

      Sem título.png