Sorting a column and adjoining pivot table at same time

Question

I have some code that creates a pivot table and then adds a column to the outside of the table that calculates a percentage of two of the columns within the table. I would like to sort that outside column, largest to smallest, but keep the pivot table aligned with the numbers. 

So columns A,B,C and D are the pivot table. Column E has the formula from B and D. 

Is there a way to link column E to the pivot table to allow me to do the sort?

Answer 1

Hi darrend7,

Regarding the query, do you still need assistance? If so, you can follow Ashish's suggestion to upload a sample file with no confidential/ sensitive data to OneDrive, then share the link here.

Best regards,

Madoc

Answer 2

Excel 365 Pro Plus with PowerPivot and Power Query.

With the latest tools.

http://www.mediafire.com/file/syc59wptp4cihuc/04_08_20a.xlsx/file

http://www.mediafire.com/file/5vvg8ao1xz4f3u9/04_08_20a.pdf/file

Answer 3

Hi,

I can try to perform the calculation within the Pivot Table itself.  Please share the link from where I can download your workbook.

Answer 4

Hi Madoc,

I am trying this, but I don't think it works for my situation. The field I am using is broken into two columns with a Grand Total. In the image below. Column F shows the value of B3/D3. You can see "Overdue Tasks" is the field and "On Time" as well as "Overdue" are values of that one field. and the numbers below are the "Count of Task_Responsible"

Hope that makes sense.

Answer 5

Hi darrend7,

You can create formulas in the PivotTable to meet your requirement.

As showing in the image, select a cell in PivotTable and click Fields, Items & Sets > Calculated Field under PivotTable Analysis, put a formula in the box, a column would be added to the right. Then you can sort the column according to your needs like from large to small.

Best regards,

Madoc