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

AtzdGr8
AtzdGr8
in Modeling

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

Answers

  • PujithaB
    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

    Thanks
    Pujitha

  • AtzdGr8
    AtzdGr8

    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.

Categories