How to Filter reports and sum data columns

Hi there,

I am having some problems and I may be missing something with how i can trying to do it!

Firstly I can filter my table I can not seem to filter a Report based on a table. Is this possible?

Secondly I want to be able to chart but based on a sum of some columns.

e.g. table contains date, name and data columns. I want the X axis to be date, Y axis to be the sum of the data columns and therefore the labels to be the names.

Any help would be appreciated.

Thanks

Tim