Exclude future months from bar chart

[#1]

Hi,

Please find my sample solution and required excel files attached.

I want to exclude future months from the dimension based on the month selection.

The business logic is: When the user selects July, only data for July from July file should be displayed because it doesn’t make sense to show data from future files.

Whereas when user selects Aug it should show Aug data from July file as well as from Aug file but not from Sep file.

And lastly when a user selects Sep it should show data for Sep from all the three files.

Attached is a sample screen shot of expected solution.

Appreciate all the help.

Regards,

Sachin

[#2]

Thanks Stefan.. The issue was with FileName.