yes using excel microsoft 365
PIVOT TABLE
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(313.6, 67%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
CT
20
Reputation points
Hi All
trying so hard to learn this but flopping please sheet trying to get totals & also deduct payments
but mainly we need the totals owed treid pivot but see results we got cant get it straight.
any suggestion how to get it right ?
many thanks for your effort helping out here Amex 8-21-25-test-QA.txt
Windows for home | Windows 11 | Files, folders, and storage
2 answers
Sort by: Most helpful
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(48, 27%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EI%3C/text%3E%3C/svg%3E)
IGYQ 19,610 Reputation points Independent Advisor2025-09-16T16:13:06.6133333+00:00 Hi,
Are you using Microsoft excel? Are you getting any errors? Can you share the screenshot?