8 Replies Latest reply: Nov 15, 2017 3:50 AM by Hima Bindu Chadalawada RSS

    Current Selection in Set Analysis

    Hima Bindu Chadalawada

      Hi,

      how can i exclude current selection in set analysis for example if i have 2017Q1 data if i select this it should show only 2016Q1 and 2016Q2 it shouldn't show 2017Q1. my expresiion is as below

       

      =if(YearQuarter = '2017Q1',

      count({<YearQuarter={'2016Q1'},YearQuarter={'2016Q2'} >} ITEM))



      please help me