在数据透视值内对excel进行排序 [英] Sorting in excel within a pivot value

问题描述

在excel中，通过按行/列标签排序可以让您按该指标的总计"数量进行排序.例如，如果我想按美元的总计"总和排序，我可以这样做:

In excel, sorting by the Row/Column labels allow you sort by the "Total" amount for that metric. For example, if I want to sort by the "Grand Total" SUM in USD, I can do:

如何在列的特定值内排序?例如，如果我想在美国"列中获得以美元为单位的销售金额-

How would I sort within a particular value of a column? For example, if I wanted to get Sum of Sales in usd in the "US" column --

有没有一种方法可以对特定列中的值进行排序?

Is there a way to sort by values within a particular column?

推荐答案

您必须右键单击要排序的列的内容.

You have to right click where the content of the column you want to sort is.

然后Sort> Sort Smallest to Largest/Largest to Smallest

我正在使用MS Office 2013中的Excel.

I'm using Excel from MS Office 2013.

这篇关于在数据透视值内对excel进行排序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！