| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
An Issue with sub-total
What is the best way to do this :
I have several columns in my spreadsheet, I sub-totaled every change in Sta tement. When i compress the file, of course, the only visible rows are the sub totals which says: statement1 total xxx statement2 total xxx statement3 total xxx is there a way for me to see the column contents so that my spreadsheet will look like this : Account Statment Amount 1000 Statement1 total xxxx 2000 Statement2 total xxxx 3000 Statement3total xxxx I tried data fill. But wont work thanks and have a great new year everyone del |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
An Issue with sub-total
Sounds as you could use a pivot table instead
http://peltiertech.com/Excel/Pivots/pivottables.htm http://www.contextures.com/xlPivot02.html -- Regards, Peo Sjoblom (No private emails please) "arcticale" wrote in message ... What is the best way to do this : I have several columns in my spreadsheet, I sub-totaled every change in Sta tement. When i compress the file, of course, the only visible rows are the sub totals which says: statement1 total xxx statement2 total xxx statement3 total xxx is there a way for me to see the column contents so that my spreadsheet will look like this : Account Statment Amount 1000 Statement1 total xxxx 2000 Statement2 total xxxx 3000 Statement3total xxxx I tried data fill. But wont work thanks and have a great new year everyone del |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
An Issue with sub-total
I have two columns with values in my worksheet. is there a way I can put this
side by side when I do the pivot table. Usually, it is one over the other. thanks a lot "Peo Sjoblom" wrote: Sounds as you could use a pivot table instead http://peltiertech.com/Excel/Pivots/pivottables.htm http://www.contextures.com/xlPivot02.html -- Regards, Peo Sjoblom (No private emails please) "arcticale" wrote in message ... What is the best way to do this : I have several columns in my spreadsheet, I sub-totaled every change in Sta tement. When i compress the file, of course, the only visible rows are the sub totals which says: statement1 total xxx statement2 total xxx statement3 total xxx is there a way for me to see the column contents so that my spreadsheet will look like this : Account Statment Amount 1000 Statement1 total xxxx 2000 Statement2 total xxxx 3000 Statement3total xxxx I tried data fill. But wont work thanks and have a great new year everyone del |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
An Issue with sub-total
Try this:
Using the Pivot Table..... Left-Click and hold on the column heading for the amounts. Drag it to the right until it covers the "Total" column heading. Release. Does that help? *********** Regards, Ron XL2002, WinXP-Pro "arcticale" wrote: I have two columns with values in my worksheet. is there a way I can put this side by side when I do the pivot table. Usually, it is one over the other. thanks a lot "Peo Sjoblom" wrote: Sounds as you could use a pivot table instead http://peltiertech.com/Excel/Pivots/pivottables.htm http://www.contextures.com/xlPivot02.html -- Regards, Peo Sjoblom (No private emails please) "arcticale" wrote in message ... What is the best way to do this : I have several columns in my spreadsheet, I sub-totaled every change in Sta tement. When i compress the file, of course, the only visible rows are the sub totals which says: statement1 total xxx statement2 total xxx statement3 total xxx is there a way for me to see the column contents so that my spreadsheet will look like this : Account Statment Amount 1000 Statement1 total xxxx 2000 Statement2 total xxxx 3000 Statement3total xxxx I tried data fill. But wont work thanks and have a great new year everyone del |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
An Issue with sub-total
THANKS RON!!!!!!!!!!!!!!!!!!!!
"Ron Coderre" wrote: Try this: Using the Pivot Table..... Left-Click and hold on the column heading for the amounts. Drag it to the right until it covers the "Total" column heading. Release. Does that help? *********** Regards, Ron XL2002, WinXP-Pro "arcticale" wrote: I have two columns with values in my worksheet. is there a way I can put this side by side when I do the pivot table. Usually, it is one over the other. thanks a lot "Peo Sjoblom" wrote: Sounds as you could use a pivot table instead http://peltiertech.com/Excel/Pivots/pivottables.htm http://www.contextures.com/xlPivot02.html -- Regards, Peo Sjoblom (No private emails please) "arcticale" wrote in message ... What is the best way to do this : I have several columns in my spreadsheet, I sub-totaled every change in Sta tement. When i compress the file, of course, the only visible rows are the sub totals which says: statement1 total xxx statement2 total xxx statement3 total xxx is there a way for me to see the column contents so that my spreadsheet will look like this : Account Statment Amount 1000 Statement1 total xxxx 2000 Statement2 total xxxx 3000 Statement3total xxxx I tried data fill. But wont work thanks and have a great new year everyone del |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
An Issue with sub-total
You're very welcome...I'm glad that worked for you.
*********** Regards, Ron XL2002, WinXP-Pro "arcticale" wrote: THANKS RON!!!!!!!!!!!!!!!!!!!! "Ron Coderre" wrote: Try this: Using the Pivot Table..... Left-Click and hold on the column heading for the amounts. Drag it to the right until it covers the "Total" column heading. Release. Does that help? *********** Regards, Ron XL2002, WinXP-Pro "arcticale" wrote: I have two columns with values in my worksheet. is there a way I can put this side by side when I do the pivot table. Usually, it is one over the other. thanks a lot "Peo Sjoblom" wrote: Sounds as you could use a pivot table instead http://peltiertech.com/Excel/Pivots/pivottables.htm http://www.contextures.com/xlPivot02.html -- Regards, Peo Sjoblom (No private emails please) "arcticale" wrote in message ... What is the best way to do this : I have several columns in my spreadsheet, I sub-totaled every change in Sta tement. When i compress the file, of course, the only visible rows are the sub totals which says: statement1 total xxx statement2 total xxx statement3 total xxx is there a way for me to see the column contents so that my spreadsheet will look like this : Account Statment Amount 1000 Statement1 total xxxx 2000 Statement2 total xxxx 3000 Statement3total xxxx I tried data fill. But wont work thanks and have a great new year everyone del |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Subtotals in a Pivot Table | Excel Discussion (Misc queries) | |||
| matching the column b(sku)c(count)with A | Excel Worksheet Functions | |||
| Percent of total in Pivot tables | Excel Worksheet Functions | |||
| Total remaining formula | Excel Worksheet Functions | |||
| Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
Linear Mode
