I need to create one chart with one dimension (Company) with two expressions - New Customers and Active Customers.... I'm trying to use Set Analysis, with the P() and E() functions. This chart has the condition to calculate only with one month selected.
New Customers: customers that have bought in the selected month and never before Active Customers: customers that have bought at least one time in the past 6 months (selected month included).
I'm trying something like this (don't work): Count( {$<nCdCustomer = P({1<data = {"<=$(=monthstart(max(data)))"}>} nCdCustomer)>} distinct nCdCustomer)
