PDA

View Full Version : Solved: Help with Pivot Tables



Klartigue
06-01-2012, 06:55 AM
Please see the attached spreadsheet. On the "Security Filter" sheet, I have two pivot tables, which are both derived from the data on the "Trades" sheet. In cell D4 and E4, as you can see I have %Buy and %Sell. For a selected security type(filter for pivot table) I would like to be able find the % each broker bought out of the total buys. So for example in cell D5, it would be cell B5/ cell B66. And do that same formula for column E. Although, as you change the security filter the pivot table may differ in size so would i get these formulas to be derived for the data displayed in the pivot table? So when I change the pivot table filter, the formulas change to reflect the pivot table.

Bob Phillips
06-01-2012, 07:45 AM
Use

=IFERROR(GETPIVOTDATA("Quantity ",$A$3,"Broker ",$A5,"Side",B$4)/GETPIVOTDATA("Quantity ",$A$3,"Side",B$4),"")

and

=IFERROR(GETPIVOTDATA("Quantity ",$G$3,"Broker ",$G5,"Side",H$4)/GETPIVOTDATA("Quantity ",$G$3,"Side",H$4),"")

Klartigue
06-01-2012, 08:04 AM
Thats works great!!! Thank you!!!!