Hiding Specific Fields on Pivot Table Fields

Hello guys,

Does anybody know any way to hide specific fields on the Pivot Table Fields List?

Explaining a little bit better....

I have a huge database, with many columns as volume sold, price, cost and so on.
And still, many calculated field.

The problem is that there too many fields on the list where I select what I want and most part of them are used only on the formulas. So I will never use it on the "visual" part of the pivot table.

To avoid this mess, I would like to hide all unnecessary info.

So even with many columns, it should present to the final user only some of the calculated fields.

See the example (and sorry, but my Office is portuguese). I have to let only part of these fields.

How can I do that?

Thanks in advance.

Maybe I was not totally clear.

Try to give an example to a better understanding...

I have a database with volumes sold and total revenue.
As I need to calculate the avg price for each customer or product, I created a calculated field:

AVG Price = Total Revenue / Unit sold

As on the pivot table (for the final user) I don't need to show the total values, only Units and AVG Price, I would like to hide the Total Revenue.
Considering that this case repeats to at least 15 different items, my fields list has a lot of "useless" items that I prefer to hide (avoid messy and mistakes).

Any way to do it?


Regards,

See the file with the example.

My intention is to avoid unnecessary items on the PivotTable Field List, because there is to many items and user will play with only some of them.

I can't do that.

Because for every different layout or filter I did, the calculate field (avg price) must be recalculated.
So, if I make a database without Total revenue, i can't do the avg price (formula)

and.... completing...

I don't want to show Total Revenue on the PivotTable Field List.
Only the avg price (CF).


regards,