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 ?