
MJ Thulasi
Member
Members

Forum Posts: 33
Member Since:
November 27, 2020
November 27, 2020

Hi all
I created a pivot table with two columns - 1. sales value - monthwise and 2. running total (from same sales value using "show value as" function in pivot table option)
My problem is I am not able to use this running total column in pivot table in calculated field. This running total column is not showing as field in the calculated field dialogue box.
Is there a way to solve this? Pls help.
Rgds
Thulasi

Mynda Treacy
Admin

Forum Posts: 4515
Member Since:
July 16, 2010
July 16, 2010

Hi Thulasi,
You need to add a calculated field that takes the balance minus the debit column first, then set this column to calculate as the running total. See file attached.
Mynda

Answers Post
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Kathleen Silva
Guest(s) 9
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 873
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 222
Jessica Stewart: 215
A.Maurizio: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
Anthony van Riessen
Erlinda Eloriaga
Abisola Ogundele
MARTYN STERRY
Rahim Lakhani
Ngoc Qui Nguyen
Clement Mansfield
Rose .
Bindu Menon
Baruch Zemer
Forum Stats:
Groups: 3
Forums: 24
Topics: 6352
Posts: 27779
Member Stats:
Guest Posters: 49
Members: 32319
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen
© Simple:Press —
