johnywhy
New Member
- Joined
- Sep 12, 2008
- Messages
- 47
- Office Version
- 365
- 2019
- 2016
- 2013
- 2011
- 2010
- 2007
- Platform
- Windows
- MacOS
<style></style>problem: i renamed a pivot field item. it's a 'year' field.
i renamed '2006' to 'donut'. then i renamed it from 'donut' back to '2006'.
now that item will not sort correctly anymore.
i tried setting it's number type to 'Number' or 'text', but neither works.
i tried copying the format of another item, '2005', to this item, but it still won't sort properly.
the microsoft doc says pivots with OLAP sources will get restored to original fieldnames if you hide and then unhide the field, but that does not work here. It's not an OLAP source, anyway.
how can a restore a field item back to the original value?
Thanks
i renamed '2006' to 'donut'. then i renamed it from 'donut' back to '2006'.
now that item will not sort correctly anymore.
i tried setting it's number type to 'Number' or 'text', but neither works.
i tried copying the format of another item, '2005', to this item, but it still won't sort properly.
the microsoft doc says pivots with OLAP sources will get restored to original fieldnames if you hide and then unhide the field, but that does not work here. It's not an OLAP source, anyway.
how can a restore a field item back to the original value?
Thanks