7 Replies Latest reply: Apr 4, 2018 11:00 AM by Stephen Hasson RSS

    Show column values conditionally?

    Stephen Hasson

      Hi,

       

      I have a data table which shows monthly sales in a grid, i.e. 12 columns, plus a total in 13th column.

       

      Using set analysis, it correctly shows the total of the selected months, e.g  when Jan, Feb selected it will only show Jan+Feb numbers, however other months' figures are still displayed in the grid, which is confusing / wrong to look at.

       

      What syntax would I use to have the 'unselected' months show a blank column?

       

      Jan expression is : Sum({$<[FiscalPeriodText]={'3~January'}>}ExtPrice)

      Feb expression is : Sum({$<[FiscalPeriodText]={'4~February'}>}ExtPrice)

      Total expression is: Sum(ExtPrice)

       

      Screen shot attached.

       

       

       

      (3 and 4 are our fiscal month numbers).

       

       

      thanks.