Forum Discussion
LOOKUPVALUE within same table???
Hi all, I am having trouble creating a new calculated column that returns the value in one of my columns, based on filters from 3 different columns in different columns within the same table (See...
Hi HCC
I have some questions that:
1. What the actual value you want to return, [area_tips] or [month1_emplvl]?
2.What does the "for the rest of the [area_fips] codes by their [Year & Quarter] and [Industry_Code" mean, what is the format it sholuld return?
Can you provide some expect result or more sample data? Is the picture i supplied you want?
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.