Pivot table subtotals help needed
 

Dear all,

I have the following details data:
month
week_start_date
profit_or_loss : signed amount
pl : "profit" if above 0, "loss" if above < 0
sector

I have created a pivot table with
month, week_start and pl as column fields
sector as row field
profit_or_loss as data field

So, for instance, for the month of april I get the following

APRIL APRIL Total
01-04 05-04 12-04
profit loss profit loss profit loss
10 0 5 -2 3 1 17

I'd need to have in the *Month Total* column the breakdown between
profit and loss (2 "subcolumns" appearing), instead of just the net
profit/loss.

Is such a thing possible ?

TIA
anthony

If you rearrange the pivot table you could get the profit and loss
totals per month. For example, put Month and Week_Start_Date in the row
area, and PL and sector in the column area.

At the bottom of each month, you'll see the PL totals.

anthony wrote:
Dear all,

I have the following details data:
month
week_start_date
profit_or_loss : signed amount
pl : "profit" if above 0, "loss" if above < 0
sector

I have created a pivot table with
month, week_start and pl as column fields
sector as row field
profit_or_loss as data field

So, for instance, for the month of april I get the following

APRIL APRIL Total
01-04 05-04 12-04
profit loss profit loss profit loss
10 0 5 -2 3 1 17

I'd need to have in the *Month Total* column the breakdown between
profit and loss (2 "subcolumns" appearing), instead of just the net
profit/loss.

Is such a thing possible ?

TIA
anthony


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Thanks for taking the time, Debra.

I'll give it a try.

anthony