4 Replies Latest reply: Dec 22, 2017 4:27 AM by Ali Hijazi RSS

    how to show sum column wise in pivot table

    pranav gohil

      hello community,

      so here's my problem i want to show sum of amount based on the code and in the year name field

      example:

      code,name     fy year name

                               2017-18

      31                         -

      41                         -

      51                    767503.8

      61                    84231

      total of 51,61   851734.8

      71                    1021542..

      81                    309308

                <and so on>

       

       

      so can anyone help me how can i achieve this

      for now my measure is simply sum(amount)

       

      balsheet.PNG

      Please help me with this..