BottomCount in Record Selection Formula 1

[varadha72]

Hi,

Db field- Year, and Quarter Values
Output-
YEAR QUARTER VALUES
2010 10000
2011 2000
2012 25000
2013 15000
2014 1000
2016 1000
...
2020 18000

I need to filter the incoming records and display only the bottom5 years (2010-2014) and its associated Quarter Values. I do not want to filter it in SQL Server although thats simple. I need this becos I have to use this in the Charts to display only the values for bottom5 years.

Please help.

 

[NiteClerk]

Assuming that you have a field called Year, then put this in the Record Selection formula:

{DB.Year} in ["2010", "2011", "2012", "2013", "2014"]

or you could use greater than/less than. >= and <= .

If you have an actual date field you can use:

{DB.Date} in Date(2010, 01, 01) to Date(2014, 12, 31)

Hope this helps.

Bob