I use a pivot table for reporting. In the reporting sheet, I use the function
to look up in the pivot table:
=if(iserror(vlookup....;false));0;vlookup(....;fal se)).
This works. But only if the pivot table shows all products. If I choose only
one or several product I want to see the month figures from, the formula
returns with zero's. Only if I choose "show all", the formula works. Who
recognizes this and what can I do to solve it?
Thanks!