Hide Select Calculated Pivot Items

Hello Everyone,

I am running into a small Pivot Table issue.

I have lots of calculations I have put into a pivot table, would rather keep my data sets limited to non-calculated items, so I do the calculated items in the pivot table.

When I create a calculated item in a pivot table, the item shows up in every row item. I can "hide" the item on the drop down selection, but it removes it from every row item. Is it possible to hide the calculated items on a row item level.

Example:
I created a calculated item that calculates Market Share by dividing row item "customer volume" by "total market volume". So for all the customer market shares the calculated item is great! But in the "total market volume" row item it has the newly created market share calculation shown....but it calculates 100% because it calculates itself against itself.

For a visual example (see attachment), I would like to keep the items in "Customer" that are highlighted, but not the items in "Market".

Anyone know how to acheive this??
(*I know I can hide the excel row, but that really isn't practical in the event the size changes)
Many thanks!

Matt

Any ideas??

I could provide more information if it will help?

Best Regards,
Matt