Overall total for column regardless if selected or not. bdaoust[ at ]yahoo.com 23.09.2006 00:02:02 I have a pivot that counts the rows matching DBO/OE or IDI. Then for those counts, I have it broken out by producer type. So in my pivot, I have DBO/OE and IDI in the column area and producer type in the row area and ofcourse the sum of DBO/OE and IDI as the data. Now there are many producer types, but the user may select just to view two. How can I show a percentage of the ones they are viewing (checked) against the total of producer types regardless if they are checked or not. TIA Brian

Re: Overall total for column regardless if selected or not. Debra Dalgleish <dsd[ at ]contexturesXSPAM.com> 24.09.2006 12:51:40 You could create another pivot table, on a hidden worksheet, and show all the producer types in that table. Then, on the first sheet, use GETPIVOTDATA formulas outside the pivot table to calculate the percentage. For example: =GETPIVOTDATA("Units",$B$5)/GETPIVOTDATA("Units",Sheet2!$B$4) bdaoust[ at ]yahoo.com wrote: [Quoted Text] > I have a pivot that counts the rows matching DBO/OE or IDI. Then for > those counts, I have it broken out by producer type. > > So in my pivot, I have DBO/OE and IDI in the column area and producer > type in the row area and ofcourse the sum of DBO/OE and IDI as the > data. > > Now there are many producer types, but the user may select just to view > two. How can I show a percentage of the ones they are viewing > (checked) against the total of producer types regardless if they are > checked or not. > > TIA > Brian > -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html