Forum Discussion
How do you add a third dimension to a table?
hynguyen Thanks for your response.
The one problem is that suppose I have many rows for equipment, let's say 100. It will become very difficult to maintain.
I was thinking I can maintain a separate table for Division and department. However, I am not sure how to use that in a Pivot (if I have two tables).
nilanjenator In case you have much longer list of Equipment, I think you should consider using Data Model feature instead. It is like a small version of Microsoft Access (database) within Excel. Please check about it here: https://support.office.com/en-us/article/create-a-data-model-in-excel-87e7a54c-87dc-488e-9410-5c75dbcb0f7b
I can't say that Power Pivot is a "small" version of Access. These are tools for bit different purposes, no one is bigger or smaller.
