Adding another value to set analysis.

[#1]

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.

[Anonymous]

Try this COUNT({<YEAR = {'$(=Year(Today()))'}, Sales_Total={'>0'}>} DISTINCT CustomerID)

[jagan]

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.

[jayaseelan]

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,