| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
pivot table : formula to absolute reference a subtotal
pls check the attachment pic: http://www.excelforum.com/attachment...4&d=1132431812 . the grand totals are already there. what i want to do is to have cost / production amount for each cost type. the problem is there is only 1 production amount, for other types its 0. i need to always use that same production amount although vary the cost. im looking to do almost an absolute referencing operation within the pivottable. i suppose this has to be programmed with vba ? -- fax ------------------------------------------------------------------------ fax's Profile: http://www.excelforum.com/member.php...o&userid=28912 View this thread: http://www.excelforum.com/showthread...hreadid=486566 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| PIVOT TABLE FORMULA | Excel Discussion (Misc queries) | |||
| % of subtotal in pivot Table | Excel Discussion (Misc queries) | |||
| How do I remove the individual subtotal lines from a pivot table.. | Excel Discussion (Misc queries) | |||
| pivot table - hide details but show subtotal for calculated field | Excel Discussion (Misc queries) | |||
| Excel's Pivot Table & Subtotal function should have a median fie. | Excel Worksheet Functions | |||
Threaded Mode
