Forum Discussion
Lenihan
Helper III
Helper IIIBest Solution for Month to Month Analysis without Causing Duplicate Data Errors.
Hi, I'm trying to do a month to month analysis of data that does not have unique values on the key column. Now that I have to add another month on, I've come across a snag. I can't add the data bec...
Hi Lenihan,
What I was suggesting is that with the calculated table you can get all the unique CI Identifier across all your tables.
Then from tables you would create a relationship to the Calculated table.
What that then means is you could then use the Calcualted Table as a filter. And it will filter all the other tables?
Here is a blog post explaining how to create the Calculated Table - Connect any number of tables together via a common column
MalS
Resolver III
Resolver IIICan you use the CI data as a lookup table, and create a new data table that contains the Month and Status info, then join them?
For example: