Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.........
Would you be able to provide a sample to look at?