Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
Thanks for taking the time, Debra.
I'll give it a try. anthony |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Problems | Excel Discussion (Misc queries) | |||
Pivot Table unable to Include Hidden Items In Subtotals | Charts and Charting in Excel | |||
Pivot table subtotals before detail | Excel Discussion (Misc queries) | |||
Pivot Table subtotals | Excel Worksheet Functions | |||
pivot table, functions for subtotals | Excel Worksheet Functions |