Cannot sort the Difference column in PivotTable

Question

Dear Experts,

Now my pivot table has a column showing the Difference between two year (2018Q1 and 2019Q1, based on 2018Q1, i.e 2019Q1 minus 2018Q1, using the"Show Values As"). Now I want to sort from biggest to smallest on the difference column.

I right click one of the cell of Difference column --> Sort --> from biggest to smallest, the result is sort by 2019Q1 column rather than the Difference column, why is that, and how to solve it? thanks! 

Answer 1

Hi,

Broadly that is what I have done.  Additionally, I have written 2 DAX formulas as well.

Right, thanks, I finally found them:

PowerPivot tab > Calculations group > Measures drop down > Manage Measures command.

In the PivotTable they have the little fx in front of the name.

They are an aspect of PivotTables I know exist, but I have not invested the time to understand them yet.

Answer 2

Hi,

Broadly that is what I have done.  Additionally, I have written 2 DAX formulas as well.

Answer 3

Hi,

I could solve it with the PowerPivot.  You may download my workbook from here.

Hope this helps.

Answer 4

Thank Verma

Here is the demo file, my problem is highlight as yellow in the excel file:

Demo File

Answer 5

Hi BoscoCho

I am Vijay, an Independent Advisor. Request you to please prepare and upload a sample / dummy file sans confidential / sensitive data to Onedrive and share the link here.

HOW TO UPLOAD TO ONEDRIVE

1. Login to https://onedrive.live.com/ utilizing the same Login ID and Password which you have used on this forum. (or use the installed Onedrive on your computer)
2. Click Upload in the top OR drag and drop the file here.
3. After uploading, right click the file and choose share.
4. Click Copy Link.
5. Copy the link and paste the link here.