9 Replies Latest reply: Jan 30, 2018 12:15 AM by Jonathan Dienst RSS

    Pivot Chart expression

    Arpit Kharkia

      Hi everyone,


      I have a chart like

      Currently my coll% is showing coll/Setup but what i want is that the coll amount should always be divided by the first setup only, i.e 40/100,20/100,10/100 giving me 40%,20%,10%. This should be respective of each and every month. Basically i want to take the setup amount where my setup month is same as my collection month.


      Is there a way to this?