how to calculate average subtotals and grand totals for %field value in the pivot table or how can we hide this %field totals in the pivot table?

[srinivas1921]

Hi,
In my pivot table there is a fact '% of completion'.it shows all percentage values only and This pivot table shows subtotals and grand totals for all expressions but the subtotals and grand total is not required only for '% of completion' expression only.as per my requirement I need to perform avg totals for % of cometion expression only and rest all expression should be display sum totals.

Can we calculate average total only for one expression in pivot table?
Or
Can we hide % of cometion expression totals?

Note: there are two types views expanded and unexpanded available for my report.

Please provide me solution on this

Many thanks in advance.........

[sunny_talwar]

Would you be able to provide a sample to look at?