Skip to main content
Adaptive Insights
Knowledge and Support - Adaptive Insights

Can I Create A Lookup Table In A Modeled Sheet That Assigns Different Values By Plan?

Question

I have about 155 plans. A different entertainment expense amount is set per plan and these amounts are the same for all months. Our Personnel sheet has a plan column, but it does not allow me to create a lookup table. How can I put entertainment amount per plan in a lookup table?

Answer

Lookup tables can only be associated with Custom dimensions. However, you can do this by creating a Custom account. You can view the account in View by Plan mode so that you can easily enter values by plan. Then, you can create a calculated account on your Personnel sheet that references the Custom account.

 
  • Was this article helpful?