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 |
All times are GMT +1. The time now is 10:12 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com