select
     year(action_date) as year,
     ifnull(null, ' ') as month,
     ' ' as day,
     sum(qty*price) as total
from actions
group by year
union
select    
    ' ',
    month(action_date),
    ' ',
    sum(qty*price)
from actions
group by year(action_date), month(action_date)
union
select
  ' ',
    ' ',
    day(action_date),
    sum(qty*price)
from actions
group by year(action_date), month(action_date), day(action_date)