12 Replies Latest reply: Jul 25, 2014 2:54 AM by AVIRAL NAG RSS

    AND operator in set analysis

    Oscar Marquez

      Hi all,

       

           I have a pivot table as in the image below, but there's one exception only for AMS (row dim), when the role = 'Guarantee' (the role is not in the pivot), so I should remove those from the "QD" count. But how do I include that in the set analysis to say "where region<>'AMS' AND role<>'Gaurantee' " without loosing the whole AMS row?

       

      =Count({<[Report Date]={"$(MaxDate)"}>} [StatusID])

      pt.PNG.png