Managed to solve this after lot of dingging around in the forum. Please the following thred:
I split the table into 3 seprate table "Overdue", "Due in 9 Days" and "Good"
So for the Overdue table:
I used the calculated dimension (Overdue) which had a value of "Ture" or "False" (but I had only selected to show the records which were "True") and inserted it in my pivot table (far left of the table) and then hidden it from view. So when the users clicked on the calculated field it retruned records which had a "Overdue" value of "True".
Applied the same logic to the other 2 tables as well