Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need to display only new clients for a certain period, for example for 2014, or for 1 month only. Please help me.
Create a Year in your script...
Year([Start Date]) as Year
Now use below in your table
COUNT{<Year = {'$(=Year(Today()))'}>}Distinct UserNS)
Create one Master Calender table using the min/max start dates and join that to main table.
Count(Distinct{<CLNDR_YR={'$(=Year([Start Date]))'}>}UserNS)
Regards
Pradeep
If i try min[Start Date] as [min date] it say to me that it is invalid expression
And how i do it for a period? I work only for present year.