Monday, December 12, 2011
How to group currency in a pivot table for excel?
Right now I have prices in as a Row label, such as $6.51-$9.47. I want to group them from $6-$10 in 1 dollar intervals, but when i group it, it loses the currency formating and just shows general numbers- 6-7. Anyone know how to fix this?|||In your pivot table options there should be an option that says something similar to "retain original formatting." Make sure that's checked.
Subscribe to:
Post Comments (Atom)
create custom grouping for pivot table reports
ReplyDeleteThe information you have posted is very useful.60 usd to cad The sites you have referred was good. Thanks for sharing..
ReplyDelete