Problem In Date Range

[vijayit43]

Hi All,

         in my dashboard we want to that customer list which are not lie in given date range for example.

Customer	Date
CUST/000002	1-Sep-15
CUST/000003	2-Sep-15
CUST/000004	3-Sep-15
CUST/000002	4-Sep-15
CUST/000003	3-Sep-15
CUST/000005	7-Sep-15

when we apply date range between from date & To date is 3-Sep-2015 then find Which Customer which are not lie on 3-Sep-2015 for ex-,

CUST/000002,CUST/000005 HOW TO ACHIEVE IN PIVOT EXPRESSION Please Suggest..

[Gabriel]

Hi,

Once way to achieve this is to use Select Excluded.

This Action can be included in the button to select after the date range have been selected.