How do I create two bar/line charts (say for sales) in the same sheet with different date range filters for each. This will help users compare sales value for the two date ranges (user should have the ability to change the date range filter, hence hard coding wont help). Have been trying to figure this out for a while now. But don't seem to find a solution. Please help.
Thanks,
Adnan
2 answers
Thanks John. This is very helpful. I wanted to select specific weeks for comparisons. Have used OR condition with parameter to achieve this. Your suggestion helped save me long hours of struggle.
