2 Replies Latest reply on Dec 19, 2017 6:21 AM by lukasz.c

    Customize Total to show sum for selected month

    lukasz.c

      Hi,

      For given data I need to calculate Change % vs previous month (thats done using lookup in filter pane)

      The problem is with Total - it shows me 48 for whole months in datset but I need to show total only for selected month. I started to build alternative total with SIZE() but I stuck how to pass parameter with date to calculate total for selected month from filter.

      I've attached sample workook

      Can anyone help me to solve this issue? Thanks in advance