Hello!

I would like to know if I can build a predefined categories in pivot table.

I have build a master template that I copy the data to it after I SUM all the data that I need.
Pivot table is great for my use but it is only SUMing the categories which are on the DB.

on the master template I have all the categories that are available which are not necessary being usd.
after working on the pivot I copy the information using a VlookUp

If 1 or more categories are missing on the monthly DB (since no-one used the category) the pivot will not show that category and then the Vlookup will not work.

I want to build like a master pivot table with predefined categories in the column section that will return 0 if not founded in the DB.

is it possible?

TNX!