Thank you John. It was a great help.
how about the other question (#2)? Any idea?
Mohsen, I don't understand question 2. Can you walk through a specific example?
Thanks John for your reply. John Sobczak
Example: In a separate sheet, I want to show the exact same chart, but only for the last 5 data sources.
What I can think of is to filter based on the path and choose the last 5, but when I'm doing this, the numbers we've calculated in calculated fields still show the number before filtering. I mean although there are only 5 lists, we will see the same numbers 16, etc. Is there a way to apply the filter to calculated fields, or am I doing the whole thing wrong?