View Single Post
  #1   Report Post  
anthony
 
Posts: n/a
Default 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