Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
I am trying to add another expression to my set analysis and I am having a bit of trouble.
COUNT({<YEAR = {'$(=Year(Today()))'}>} DISTINCT CustomerID)
I need to add the following to the set analysis:
COUNT({$<Sales_Total={">0"}>} Sales_Total)
Any help will be appreciated.
Thanks.
Try this COUNT({<YEAR = {'$(=Year(Today()))'}, Sales_Total={'>0'}>} DISTINCT CustomerID)
Hi,
Try this
COUNT({<YEAR = {'$(=Year(Today()))'}, Sales_Total={">0"}>} DISTINCT CustomerID)
Like this you can add any number filters in Set analysis.
Regards,
jagan.
Hi,
For finding count of customerID according to your filtration is below,
COUNT({<YEAR = {'$(=Year(Today()))'}, Sales_Total={">0"}>} DISTINCT CustomerID)
For finding count of Sales_Total according to your filtration is below,
COUNT({<YEAR = {'$(=Year(Today()))'}, Sales_Total={">0"}>} DISTINCT Sales_Total )
Thanks,