Thanks Dan, I'm trying it, and it only removed on September of 2012. Any clue what I'm doing wrong?
Here are steps I took:
1. Created a calculated field named "2012 remove" with formula "index()!=1"
2. Dragged the "2012 remove" pill to the detail box in Mark "All"
3. Right clicked "2012 remove", Edit Table Calculation, Advanced, Moved Year of Month Year to the right
4. Filtered out False
Can you post your workbook?
I just posted it in my previous post. Thanks
Here you go.
The issue was that your compute using was still set to Table Across. Right click the filter and select Edit Table Calculation to explore what I changed. The steps are outlined in my previous post.
Also, I cleaned up the viz a little bit by putting the 50% calc in the viz as a reference line rather than a measure on the second axis. This cleans up a the view a bit as the line now extends across the whole pane.