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!
Bookmarks