Hello:
I have a straight table with DM #, Project ID, Estimate ID, Estimate Item ID, Project Name, Order Quarter, Foundation, Foundation_1, LOB, Site and then an expression calculating quantity. The expression is below. I have Dropdown Select checked for Estimate ID and Estimate Item Id. Since I'm limiting the straight table to a specific DM #, I would expect to only have the associated Estimate ID (should be four of them) and Estimate Item ID associated to the four Estimate ID's (there should be 36 distinct Estimate Item IDs).
Instead when I click on the black down arrow to choose, for example, a specific Estimate Item ID, the list of choices that is presented is all the possible Estimate Item ID's that are in the data model. Same for Estimate ID (Project ID as well - should only be one). Is there a way to limit the possible selections to the 4 Estimate ID's and 36 Estimate Item ID's? Worst case, I could just uncheck Dropdown Select for both columns.
Expression that calculates the Quantity amount:
If(Num(Rank(TOTAL Sum({<project_include_in_forecast = {1},project_is_active = {1},
estimate_include_in_forecast={1},estimate_is_active ={1}, [DM #] = {'88888888888-11'}, [Item Action]={'Add'} ,
Foundation *= {'VSI'}
>} effective_item_qty))) < 500,
Sum({<project_include_in_forecast = {1},project_is_active = {1},
estimate_include_in_forecast={1},estimate_is_active ={1}, [DM #] = {'88888888888-11'}, [Item Action]={'Add'} ,
Foundation *= {'VSI'}
>} effective_item_qty))
Thanks in advance.
