Hi - I am trying to create a drill though on the Bar View where at the high level it shows all the buyer in my organisation and when i double click on it i want it to drill though to all the suppliers associated with that buyer. - Any thoughts?
Use two Bar views. Set the bottom one to "Subset: Selected data". When you select in the top one, you'll see just that selected subset of rows displyed in the bottom one.