beadedbytes
Technical User
I've recently created some calculated fields inside a Excel 2013 Pivot table. And, there seems to be some 'unexpecteds' when using them.
Let's say I have a field with Source_Name='Rsp_Prcnt'. After creating the calculated field, I've assigned the metric Custom_Name='Resp%' as the Column Label. FYI ... This is just one of 5 calculated fields in the Pivot Table.
When I deselect this field from the pivot view and then reselect it, the field label changes back to Source_Name 'Sum of Rsp_Prcnt'. The Custom_Name needs to re-established and the resulting values need to be formatted again as a percent.
Also, if I want to move just one of the calc fields from column to row, I can only do so by moving ALL the calculated fields to row labels.
First, are there workarounds for these particular issues?
Second, is there a good summary document of the pros/cons of Calculated Fields in Pivot Tables? I've come across a few docs on the internet with cautionary information about how these fields treat Totals in Pivots and am curious about other things that one should be mindful of when using this feature in Excel.
Let's say I have a field with Source_Name='Rsp_Prcnt'. After creating the calculated field, I've assigned the metric Custom_Name='Resp%' as the Column Label. FYI ... This is just one of 5 calculated fields in the Pivot Table.
When I deselect this field from the pivot view and then reselect it, the field label changes back to Source_Name 'Sum of Rsp_Prcnt'. The Custom_Name needs to re-established and the resulting values need to be formatted again as a percent.
Also, if I want to move just one of the calc fields from column to row, I can only do so by moving ALL the calculated fields to row labels.
First, are there workarounds for these particular issues?
Second, is there a good summary document of the pros/cons of Calculated Fields in Pivot Tables? I've come across a few docs on the internet with cautionary information about how these fields treat Totals in Pivots and am curious about other things that one should be mindful of when using this feature in Excel.