Pivot Table

[marty007]

I created a pivot table. I want to get the total trips each person has gone on. In othe rpivot tables , a Totals column automatically appears. I can only get the count by creating a column outside of the pivot table. See my attached pivot table. I would also like to be able to sort the pivot table from highest to lowest.

[#2]

@marty007 

You may allow rows total in options

and select sorting by count

[#3]

The grand total worked fine. But I was unable to sort correctly. I'm trying to sort by grand totals. I'm not sure where you got that sort screen from. It looks different than Data, Sort.

[#4]

@marty007 

If step by step

next

next

[#5]

Works perfectly, thank you.

[#6]

@marty007 , glad to help

[#7]

This worked thank you very much.

[#8]

@marty007 , you are welcome