Solved: Help with Pivot Tables

[Klartigue]

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]

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]

Thats works great!!! Thank you!!!!