So does this mean you only want to show January or the first month of the quarter? A conditional formula might look like the following:
if year([Order Date])=2013 and datepart('quarter', [Order Date])=1 and month([Order Date])=1 then 'Keep' else 'Hide' end
Then, place this on the filter shelf and select Keep.
Hope this helps!
My 'Appointment Date.Fiscal Year' field is a text field and it contains Fiscal Year and Quarter and Month and Date. I have parameters for 'Fiscal Year' and a parameter for 'Month' and I can use these in a conditional formula in the filter, but I do not know how to use them together. Here is what I was trying:
[Appointment Date.Fiscal Year]=[Fiscal Year] and [Appointment Date.Fiscal Year]=[Month]
Is there a way to do this?