Excel 2013 Pivot Table Data Crunching is a great book. I suggest that you have a look at the information about calculated fields though. There seems to be some misunderstand regarding how calculated fields work.
Calculated Fields do not calculate on a row-by-row basis as stated on page 244. They are not like calculated columns in Power Pivot; more like a very basic version of calculated fields in Power Pivot (only sum is supported). Calculated fields operate on the sum totals in the pivot table, not on the underlying rows.
Also, method 1 on page 114 is equivalent to creating a calculated column in Power Pivot. Ratios cannot be summarized however. Well, they can of course, but you will not get the correct results, without using weights at least. Hence, a calculate field (method 3) is the right way to go.
I'm sorry for having to bring this to your attention. It is still a great book that you guys have written! Keep up the good work.
Mr T
Calculated Fields do not calculate on a row-by-row basis as stated on page 244. They are not like calculated columns in Power Pivot; more like a very basic version of calculated fields in Power Pivot (only sum is supported). Calculated fields operate on the sum totals in the pivot table, not on the underlying rows.
Also, method 1 on page 114 is equivalent to creating a calculated column in Power Pivot. Ratios cannot be summarized however. Well, they can of course, but you will not get the correct results, without using weights at least. Hence, a calculate field (method 3) is the right way to go.
I'm sorry for having to bring this to your attention. It is still a great book that you guys have written! Keep up the good work.
Mr T
