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: Hans Hallebeek
Guest(s) 8
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1939
SunnyKow: 1432
Anders Sehlstedt: 918
Purfleet: 415
Frans Visser: 349
Hans Hallebeek: 333
David_Ng: 306
lea cohen: 248
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
Crystal Harris
Amaan Abdi
Sarah Yelland
Ahsan AYUB
Daniel Neilson
Joy Nicholes
Earl Hanlon
Paulo Pinto
Tavonga Machigere
Marc Poulopoulos
Forum Stats:
Groups: 3
Forums: 25
Topics: 7058
Posts: 30934
Member Stats:
Guest Posters: 49
Members: 34430
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —