4 Replies Latest reply: Feb 19, 2018 7:10 AM by bruno bertels RSS

    Aggr function

    Sofia Vaz

      Hi all,

       

      I'm trying to calculate de % of transfers by status per market and mill.

       

      In order to do that, i've drawn a pivot table and, so far, i've only been able to aggregate my function per market... Can you help doing it also by mill? (The sum per mill and market has to be 100%)

       

      My current expression is this one:

       

      =count(AllocTransfAllocTransfId) /aggr(NODISTINCT count(AllocTransfAllocTransfId),AllocTransfOrigMktDescrip)

       

      Thanks!