gmooney
Active Member
- Joined
- Oct 21, 2004
- Messages
- 252
- Office Version
- 365
- Platform
- Windows
I have a pivot table that I am unable to make a calculated field work in the pivot table (maybe due to my lack of using pivot tables). So I created the formulas in the first column to the right of the pivot table.
This would be acceptable except for when the user changes 1 of the 2 filters the formula rows might not line up correctly to the corresponding pivot table rows.
I then thought if I used the getpivotdata formula that would ensure that the formulas would follow to the correct row BUT again, even though the formula might have the correct result if the row changed, the formula row won't change?
Any thoughts?
Below is a print screen because I can't figure how the new Mr. Excel Capture
The column with the 77.7% is the column that is NOT a part of the pivot table. The formula for that is simply the 20.7/11.6-1. The formula will always be Brand 1/Brand 2. In this example under Bag Small there is no Brand 2 som. no calculation and it Clamshell Small disregard the 4.5oz item
This would be acceptable except for when the user changes 1 of the 2 filters the formula rows might not line up correctly to the corresponding pivot table rows.
I then thought if I used the getpivotdata formula that would ensure that the formulas would follow to the correct row BUT again, even though the formula might have the correct result if the row changed, the formula row won't change?
Any thoughts?
Below is a print screen because I can't figure how the new Mr. Excel Capture
The column with the 77.7% is the column that is NOT a part of the pivot table. The formula for that is simply the 20.7/11.6-1. The formula will always be Brand 1/Brand 2. In this example under Bag Small there is no Brand 2 som. no calculation and it Clamshell Small disregard the 4.5oz item