ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I get a pivot table to sort based on the data items sectio. (https://www.excelbanter.com/excel-worksheet-functions/21473-how-do-i-get-pivot-table-sort-based-data-items-sectio.html)

Steve

How do I get a pivot table to sort based on the data items sectio.
 


JulieD

Hi Steve

please repost with your question in the message body as it's been truncated
and isn't very clear.
--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Steve" wrote in message
...




Sunil Jayakumar

Hi Steve,

Just click on any cell containing data in the column you want to sort. Then
DataSort, and this will give you a sort menu. It does trigger a different
one when in a Pivot Table.

Hope this helps

Sunil Jayakumar

"Steve" wrote in message
...


www.ayyoo.com/loans.html




All times are GMT +1. The time now is 09:52 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com