1 Reply Latest reply: Jun 11, 2018 5:11 AM by Sunny Talwar RSS

    Chart to show all Values when 0 and filtered down upon

    Aaron Dhobi

      Hi Guys,

       

      Bit of a technical question.

       

      I need my chart to show certain values when they are null

       

      I have 5 items

      Tshirts

      Jeans

      Shirts

      Shoes

      Accessories

       

      Only some [Shops] have these items.

      In [Reporting period] only some of these items have been sold depending on time.

       

      I want when i filter down to show all the null values that are assoicated to each shop and Reporting Period

       

      For example: London shop only sells Tshirts and Jeans. Birmingham shop sells Shoes and accessories.

      If i filter on London I want to see all the items that did not sell, The 0s basically.

       

      I have been able to achieve what I want when I filter on shop but not on Reporting period.

       

      Sum({<Shop+={' '}>}[Item])

       

      Is there a way to add in reporting period? To make the result dynamic to the two filters? ([Shop], [Reporting Period])

       

      Thanks,

      Aaron