This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](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(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Is it possible to sum rows in pivot table which contains columns of sum function? For example, in this table i need to have one more column at the end of pivot table which will represent the sum or grand total of every row(process). Thanks in advance.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
You will have to use Calculated Field for this.
Click anywhere in the pivot > Analyze tab > Fields, Items & Sets > Calculated Field > Give it a name in Name: box > In Formula: box > Put following (Copy and paste from below)
= 'Loss 1'+ 'Loss 2'+ 'Loss 3'
Hi,
Using "Unpivot Other columns" under Data > Get & Transform, convert your dataset into a 3 column Table - Process > Loss and Value. Build your Pivot Table from there and you will get your desired output.
I got it. It works. Thanks a lot! :-)