Lookup Monthly GL Figures for Management Report

Hi,

I will tried to explain this as well as I can as to what I am after.

I am creating a dashboard for my management team (individual states).
I have all the information downloaded for the first couple of month of the year, and what I want to do is when you select which "state/division" you wish to view it returns those figures for each month that the figures are available for.

IE if you select NSW, only NSW Turnover, Overhead Expenses etc are shown.

Thanks Guru's