This content has been marked as final. Show 4 replies
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.)