Pivot table which displays only the total for some of the fields

[moty.98]

I'm connecting to DB in order to display a pivot table. I'd like for example to see the weekly cost by weeks by country as in the example. I'd also like to get the cost - but only in the sum (and not see the weekly costs).
How can I do that?
I'd like to see the table as in the file but without the red columns.


I also thought of trying to do this by using 2 tables, but the thing is that the cost appers in all countries, but the income doesn't appear in all of them, and then the tables aren't synced when placed one by another.



Thank you,

Moty