Level 1 Model Building EMP02 Employee Expenses Module Dimensions

Hello,

 

I am currently in the process of going through the Level 1 Model Building course. In section 10, I was instructed to create a module with the dimensions: #E2 Employees, Active?, Time

 

The problem is that I don't see Active? anywhere in my model, except maybe as a line item in a separate list or module. Regardless, it isn't an option on the list when creating the module. Where would I find this, or how do I add it?

Tagged:

Best Answer

  • JaredDolich
    Answer ✓

    @ws696201 

    Very common question. Thanks for asking.

    What you are referring to is what's called a list subset.

    the benefits of a list subset is that you can narrow the list to a smaller set of list items. This reduces your overall module size as well as make it easier to work with.

     

    In the #E2 Employee List you can find the list subset.

    EMP02A.png

     

    When you build your module you'll drag this list subset into your pivot.

    EMP02B.png

Answers

  • I'm not sure why the formula isn't populating the data for those selections within activity 10.2.6. Any suggestions or will there be an additional input for this data in another lesson?