BLACK FRIDAY SALE 20% OFF ALL COURSES

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: 4647
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: Wang, Jude Livingston, Richard Cook, Garry Gregson
Guest(s) 10
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1864
SunnyKow: 1432
Anders Sehlstedt: 886
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 241
Hans Hallebeek: 225
Jessica Stewart: 219
A.Maurizio: 213
Newest Members:
Robert Corbyn
Tamara Nelson
Phil Collins
Robert Moran
Mark Niemiec
Michael Groh
Paula Holbrook
Russ Cockings
Huub Poppelaars
Pieter Brandsen
Forum Stats:
Groups: 3
Forums: 24
Topics: 6639
Posts: 29131
Member Stats:
Guest Posters: 49
Members: 33081
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —
