My quick recommendation is to (in regards to your map) move account status to the color mark in the marks shelf. That will visually represent the difference between lapsed and lapsed 2 years.
As for your column question, I'm not exactly sure what you are trying to accomplish. If you want to visually represent a total sum of the sales for each year you will need to create a separate calculation. After you create that calculation, you can add that to the tooltip mark in the marks card. I hope this helps, thanks!
Totally agree with JT above on the first part! I've attached a workbook showing how you can do this more specifically. The worksheet "Account status on color" shows the colored view with all of the account statuses. To only show Lapsed and Lapsed 2 years, put account status on filters, and only show the chosen statuses (this is shown on worksheet "Filter to account status").
If I understand correctly, for "Sheet 2", you want to show sum(Sales) for the bars without getting the bars broken up by the different Customer IDs... is that correct? The reason this is happening is because you must have Customer ID on the level of detail since you are using a table calculation, "PREVIOUS VALUE" in your "Account Status" calculation. I've tried a few alternatives to previous_value, but it does seem using previous value is your best option.
My recommendation is to create a new calculations, almost identical to "# OF CUSTOMERS", but substituting sum(Sales) for each of the count distinct of customers. This will allow you to use the Sales numbers in the same way you use the customer count. In the attached workbook, this calculation is called "# OF SALES" and shown on the worksheet "Number of Sales". You can then add a reference line to each cell to show the total of these sales.
Hope that helps!
I used similar idea of defining Customer / Account Status. Graph works fine.
However, there are 2 issues -
1. I am not able to count # of customers with each of the status
2. I loose history of the Account Status based on selected period.. for eg. if a customer was "New" in December'2012 and "Retained" in January'13, status of the customer will change to "New" if you selected period of January'13 as a starting period.
Not sure if you encountered same problem and how did you resolve this?