Manipulate data table below the pivot chart

Thanks Andy for your help, with your file and your help I did suceed in adding a calculated item in the pivot table and in displaying it in the data table

But, I tried to do the same thing for a total for each rows, but the result in the graph, is that this add another column, do you know if it would be possible to hide this column without hiding it in the data table ?
I'm doubting that this is possible I'm not an expert

Thanks in advance.

No problem, thanks for helping

Thanks for your solution, I will do it the manual way

Originally Posted by Andy Pope

You could use a calculated Item.

How do you use the calculated field option as in your example spreadsheet, iam trying to do a similar thing, whenever i have used the calculate field option i have done through the pivottable tools - options - fields, items & sets selections.

When using this it shows whatever calculation i have as a value in the pivot table

however when i looked at your example sheet and clicked in the cell it was showing the formula? also i couldnt see where this was stored in the calculate field option?
is there a different way of using this function than off the tool bar?