View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
BorisS BorisS is offline
external usenet poster
 
Posts: 191
Default percent of total with partial items

I have two occurences of a sales field in a pivot table. One is total sales,
and the other is percent of total sales (automatically done within field
settings, not calculated item).

I am filtering the percent of sales to show only top 100 items (again,
through field settings, advanced). But I'd like the resulting calculation to
remain percent of total, not just what's shown. How/can I do this?

--
Boris