28 Replies Latest reply: Nov 23, 2017 4:18 AM by Anil Samineni RSS

    Current Selection in Set Analysis

    Hima Bindu Chadalawada


      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