I created an aggregate formula for a table that contains expenses. The aggregate formula counted the number for expense items where the expense amount was greater than $100 - formula name was "100Plus".

I then created a pivot table with "Month-Year" as the rows and the added the "100Plus" aggregate formula as the data field.

The numbers came up as expected. For instance, in December 2012 I had 4 expense items greater than $100 out of the at transactions.

However, when I clicked on the number "4" to find the list of 4 transactions that were above $100 (drill down), the detailed list included all the transactions for the December 2012 - i.e. not filtered to the expense items that were $100 plus.

Is this expected? Or a known issue.

Cheers

Sunil