2 Replies Latest reply on Jan 4, 2013 11:43 AM by Rod Menken

    How do I create a conditional filter to select a Fiscal Year and Quarter and Month?

    Rod Menken

      I have a field for date that has Fiscal Year then quarter then month then dates.  I want to build a conditional filter formula that pulls a specific month.  The filter looks like this:

       

      FY2013

           Q1

                January

                February

       

      So how do I create a conditional formula in the filter that pulls only FY2013   Q1   January?  Should there be delimiters between the individual levels of the filter?