I have a pivot table with the configuration shown in the image attached, where in the columns I have the Plan for the Year in one column (with the months collapsed underneath), then the Monthly Results and Forecast in 12 columns, plus the Total Results and Forecast in another column. I'd like to have two extra columns called "Forecast Total vs Plan Total ($)" and "Forecast Total vs Plan Total %" within the Pivot Table (with Calculated fields, or Measures, or Sets, or whichever works). Is it possible to bring those two fields into the Pivot Table or must they remain where they are now (outside the pivot table)? Thanks.
Hi Francisco,
Nothing attached. Click on Start Upload after selecting the files/images.
Phil
Hello Phil,
Thanks. Re-sending with an screenshot file attached. I was under the impression that it had been uploaded with the earlier message. Let's hope that this time it is. Regards.
Francisco