Pivot table not showing data for a column/line which has data
295115Aug 19 2010 — edited Aug 20 2010I have a simple pivot table:
Investigator | 2010 | 2009 |
========================
Eduardo | 10 | 6 |
Adam | | 3 |
=======================
Total | 10 | 9 |
=======================
Looks good, right ? Wrong ! If I drill from the 2010 to the detailed report it shows me 20 records, where Adam has 10 records which are not showing up on the pivot. Strange thing is, when you mouse over the table where is supposed to have a value for Adam, it actually let you click and drill to the Adam's records. The value is not showing up.
This is clearly a bug, has anyone had it and how it was fixed?
Thanks!