pivot table

[nishpearl123]

i have 2 tables named "Inflow" & "Outflow"

both has 2 col. - 1. Date 2. Amount

i want to generate a pivot rreport merging these 2 tables, so that i can view my inflows & outflows together.

kindly assist.

regards,
ni****h

 

[stefankemp]

You need to create a third table, with three columns: Flow type, Date, Amount. In the Flow type column, enter "Inflow" or "Outflow" in each row.

So for example if you have 20 rows in your Inflow table, and 30 rows in your outflow table, then you will have 50 rows in the new table.

 

[DauntingGecko]

Go back to your underlying raw data, stick the two seperate sets of data together on one sheet and add a new column that shows "inflow" and "outflow". You can now pivot by this to show both categories

 

[Sandeep Warrier]

Hi

This should help you

http://www.contextures.com/xlPivot08.html