I have attached the workbook as solution to your problem:-
1) The first problem where you have mentioned that line or area chart in not changing the bar graph below what you have to do is you have to select use as filter option and then the below graph will change as per selection.
2) The second problem where you want the month to come till last month not including the current month for that you have to use the calculated field which will truncate your current month.
Hope this helps.
filter_on_date1.twbx 38.5 KB
1 of 1 people found this helpful
Thanks a lot for your help.
For number 1 the use as filter I had already used that but I was able to figure out the problem. I just had to change the data to discrete from continuous to be able to filter on the individual month.
The second one with the formula to remove latest month worked like a charm. - Thanks a lot - you rock!
Hahaha Thanks Naquiyah.