Google chart not updating filtering query

[Roy Coffin]

I have a php webpage created by php generator for mysql. I have a google pie chart on the page that is generated by this query which works perfectly.

SELECT category,SUM(amount) FROM outgoing GROUP BY category

The problem I have is the chart is static to this query, so when I run a filter on the page the chart does not update. This is the only documentation regarding this on the chart section.

"Enter an sql query to retrieve chart data. To refer to the charts parent page query,use %source% place holder."

I have tried to use the %source% place holder in many different configurations but always get SQL ERROR.
I understand why the chart is static because it only sees the query with no reference to an update. Also if I add records to the DB the charts do update to the new records.
Any help would be greatly appreciated as I cannot figure this out. Thanks in advance. Roy