Pivot table drill down wrong data

Question

Hi,

I have a pivot table that consists on data sheet. The original cells value comes from a VLoopup function that returns either a numeric value or a text that i've written in the function.

When I double click one of the sum cells in the pivot to see the drill down, i see various rows. Some are with amounts, some with zero or text that i've written in a Vlookup based cell.

How can I narrow the drill down to only the ones with values (no zero or text).

Thanks a lot in advance

Answer 1

Hi,

Welcome to Microsoft Community and thank you for posting the question.

For issues related to Pivot table, I would suggest you to post your query in the forum below for better suggestions:

http://social.technet.microsoft.com/Forums/office/en-US/home?forum=excel

Thank you.