ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   percent of total with partial items (https://www.excelbanter.com/excel-programming/332153-percent-total-partial-items.html)

BorisS

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