6 Replies Latest reply: Jan 21, 2011 8:51 PM by michaelm RSS

    Set analysis - advanced searches

    Skoezzi

      Hi,

      I'm trying to achieve the following: I want to get all the clients who have bought something in Q1/2010 and nothing in Q1/2009. I tried with following set analysis but it's not working correctly.

      =COUNT({1<_ClientID = {"=SUM({<QuarterYear = {'Q1/$(vCurrentYear)'}>} _Sales) > 0"}, _ClientID = {"=SUM({<QuarterYear= {'Q1/$(vPreviousYear)'}>} _Sales) = 0"} >} DISTINCT _ClientID)

       

      Can you help me? Thanks in advance!

       

      PS : Is there anywhere more detailed information about Advanced searches in set analysis?