Filtering concepts

HI,

I have data as

Project  cost           revenue

p1          1000              2000

P2           2000             4000

P3           3000              6000

p4           4000            10000

p5          5000              12000

Now i am trying to generate report like 

Project Cost       Revenue     Profit = rev - cost           Profit percentage= Profit/revenue

if i filter Project the report shows 

Project1  Total cost,total revenue, total profit, profit percentages

if i not filter it shows everything total

thanks