Pivot table

**rizmomin** · 11-24-2017, 10:14 PM

Hello:

Please refer to attached file.
I have table of data from Bank as shown.
I need to use Pivot Table to give output as shown in Column J thru N

Let me know if you have any questions.
Thanks.
R

**MarvinP** · 11-24-2017, 10:27 PM

Hi Riz,

See the attached where I've added a calculated item. Does this do what you want?

Pivot with added Total.xlsx

http://www.contextures.com/excelpivo...ulateditem.htm

**sandy666** · 11-25-2017, 05:40 AM

Just for fun

with PowerQuery (green table)

**shukla.ankur281190** · 11-25-2017, 06:14 AM

I would create a helper column for Opening bal in Table and will make a calculation field in pivot table for end bal.

For creating opening balance I have added a column G.

G2

Formula:

Please Login or Register  to view this content.

Now Inserted the pivot table.

For closing balance I did make a calculated field. To do so, go to the Analyze->> Calcculation->Calculated Field->Name->ClosingBal->Formula = Debit- Credit then ok.

Check the attached file hope this will help.

Pivot table

LinkBack

Thread Tools

Rate This Thread

Display

Pivot table

Re: Pivot table

Re: Pivot table

Re: Pivot table

Thread Information

Users Browsing this Thread

Similar Threads

Table to column problem to create dataset for pivot table [Bloomberg data to pivot table]

Automating Pivot table and pivot chart creation if data table names unknown

Pivot Table Conditional Formatting Dissappears / Pivot Table Leaves Colored Cells

creating a table that will link to a pivot table and change as the pivot table is changed

creating a table that will link to a pivot table and change as the pivot table is changed

Collapse/Expand - Pivot table Fields - Need equivalent option in Excel VBA Pivot table

Bookmarks

Bookmarks

Posting Permissions