Display Year Sum Value and All Year Period while in filter mode


Hi all. good day. may i know if it is possible to display only the sum year value and all year period value while in filter mode.

Best Answer


  • PujithaB

    Hi AtzDGreat

    This can be achieved by switching on summary and applying DCA to show only the year value and all periods

    Let me know if this helps out


  • AtzDGreat

    Hi @PujithaB thank you for your reply. i'm already change summary to Sum. but i'm not quite sure how to apply DCA? as of the moment i achieve the filter. but it turns out that once we do filter, all total will gone/hidden.