I am designing lost customer report , i want to restrict customer in dimension itself .
In my report my date selection is 13-sep-15 to 13-oct-15, i want to display lost customers alone in my report ,
i,e , from 13-sep-15 to current date(today date) ,we should not have any transaction between that customer , those customer we consider as lost customer .
I have selected ricoh asia customer in my report , it showing last job date as 11 th sep , but actual last job date is 13th oct (please check test sheet), so we didnt loss that customer and it should not display in report .
