That's a really interesting way of doing it, and i'll use that for another task I have to complete. However I dont need to be concerned about exposing data to the customer as this dashboard will be an internal dashboard. Is there a way of selecting the customer in a listbox and then referring to that within the expression. eg could I have 2 listboxes, in one I select "Virgin" in the other I select "VIRGIN, HMV and OURPrice, then I'd like the table to say
Can you think of a way of doing this, maybe using the "if customer=vCustomer then customer,XXXX." how do I associate the 1st listbox with the vCustomer variable?