Forum Discussion
Same Filter, Different Result
I have built a table that should sum up the projected hours on required to complete a project based on what portion of the project and phase it is in. I'm also doing a Visual Level filter based on t...
BEKwiat
Based on my understanding, I reproduce your scenario and get the expected results without any issue.
I use the following sample data.
In the Visual Level filter, it will return below screenshot if we select all the Source, the Value is the sum of different Source.
Then I select the Source1 and returns the following screenshot.
Finally, I used the inverted version of the filter. Click the Advanced filtering, filter is not Source2, not Source3. The result is same vs the filter is Source1. To note, linking works must be “and” rather “no”.
If this is not what you want, please give post more details, sample data or screenshot for analysis?
Best Regards,
Angelia