Hello All,
Well that was easy to work out :). Can do it in the TSQL,
code below just in case any one was interested.
select month(planddate) AS plandate, planpart
, sum(planoq) AS planoq
from planned
group
by month(planddate), planpart
Kind Regards Guy