Hi Siang,

Drop Customer ID to filter shelf as show below.

Thanks,

Sreekanth.

Hi,

I'm not entirely sure I understand the question, but if you created a calculated field with

IF [Year] = 2012 AND [Happy?] = 'Yes' THEN [Customer ID] END

This will create a new column that will only return the customer ID for those customers that were happy in year 1. You could then plot this new field throughout the years.

Hi,

yes, you are right. That doesn't work. I didn't have the time to play with the data before my last response so now that I have done that my next suggestion would be to create a manual group of your customers.

Set up the view with Year and CNTD of customers and filter to only happy customers. Then place the customer ID on the 'details' shelf. Now drag and select all of the bar that represents 2012. Right-click and select 'group'. It should then give you an option to group by different dimensions. Select 'customer ID' and it will create a group with all of the customers that were happy in year 1. That field will now appear in your dimensions where you can rename it. Now place that field on your filters and select only the group you want to display.

See the final setup below. I hope that works out and gets around the issue of having too many customers to manually select them in the filter. Let me know if you have questions.

Best wishes

Naledi