4 Replies Latest reply: Jul 13, 2012 8:28 AM by markvandermeij RSS

    Set analyses challenge

      Hi,

       

      I;m having problems with a seamingly simple set analyses.

      TABLE: INVOICES. (Invoice_ID, Relation_ID, Invoice_Date, 1 as Number of Invocies)

      TABLE: CUSTOMER: (Relation_ID, 1 as Number of Invoices).

      TABLE: DATE (Invoice_Date, Month, Year etc).

       

      What I want is:

      Sum ( Number of Relations   WHERE Number Of Invoices in selected time dimension = 1 ).

      Ofcourse Number of invoices should be over the selected period in the timetable.

      The formula should also work when building a graph displaying a yearmonth dimension.

       

       

      (So we can see that the number of customers with just one invoice in a period, declines.)

       

      Thanks!