Francisco Lopez
New Member
Members
Forum Posts: 2
Member Since:
April 8, 2024
April 8, 2024
Offline
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.
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online:
Guest(s) 8
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1944
SunnyKow: 1432
Anders Sehlstedt: 956
Purfleet: 415
Hans Hallebeek: 377
Frans Visser: 351
David_Ng: 318
lea cohen: 248
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
Techia Braveboy
Charles Buchanan
Tiago Braga
Rehan Baig
Fred HORVATH
Silke Schmidt
Stuart Barr
Amelia Nolte
David Wier
T P Collins
Forum Stats:
Groups: 3
Forums: 25
Topics: 7154
Posts: 31382
Member Stats:
Guest Posters: 50
Members: 34655
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —