![]() |
% of calculated field in pivot table
I was hoping to get some help with a calculated field in a pivot table.
I'm trying to create a "% of sales" formula (value of each color/total). I'm navigating to (pivot table\formula\calculated field) to build the formula, I'm lacking the knowledge to use the field items to build the formula. Any help would be greatly appreciated. Color Unit Sales Black 10 Brown 10 Red 10 Total 30 |
All times are GMT +1. The time now is 05:17 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com