4 Replies Latest reply: Oct 10, 2018 1:04 PM by Jayant Tibhe RSS

    Can if match () be used in a conditional show/hide expression ?

    Claudia Lettten

      Here is an expression for a column in a pivot table. It is a dimension not a measure


      if (match (Retailer,  'Verizon', ' Apple') , Retailer )


      So it shows  columns for Verizon  and Apple. Then there is another dimension collapse underneath +  Online Sales


        Verizon                  Apple


      +  online sales          + online sales


      How do I make Verizon and Apple show only  if there is value in Online Sales and hide if there is no value in Online Sales?


        Or how about show / hide made on latest updates in Online Sales ?