I want to use a calculated field to make a filter. Since Id (Activities) in activities table is just a series of numbers, users cannot filter the data intuitively. That's why I concatenated other columns and made Filter ID field.
However, this new field makes false items when I use it as a filter. These false items in the list do not exist in the data.
For example, if I just use Id (Activities) to filter, it shows 27 items. On the other hand, if I use Filter ID as a filter, it shows 61 items even though Id (Activities) and Filter ID have 1-to-1 relationship.
If I filter the data with false items, nothing appeared on the worksheet.
I would really appreciate it if someone can help me with this issue.
Hi,
I am not able to view the data as it is live connection.
I will tell you an easy way to troubleshoot...
I am able to see that you have added the ID(Activities) towards the end in your Filter ID(caculated field). In your Filter ID field, add ID(activities) as the first field and the view the filter again. You will be able to identify where the problem is.
Hope this helps..
