Pivot and Fixed values

Hi,

I'm struggling a bit over a pivot and I need help

I have made two pivot tables each in a different sheets. Both use data from the 'data' sheet.

My problem is that I want to have the fields: Sales 2010, profit after tax, equity and employees values fix for each firm (I only have the total for each firm - not per segment).. So if I choose a different market segment (or product) in the pivot the total will show. But if I check off that I want to see all market segments in the pivot, it goes wrong - due to I have the total more then one time in the firms marked segments.. The pivot will now add all the numbers up for all the different segments. So the total for the firm get screwed up.

I guess that the problem is even bigger in the product pivot where I want it to choose between a combination of product and market segment.

Is it possible to get pivot the way I want it to show?

Please the attached file.