FG
💻 Software

Percentile of order in excel pivot-table

Fresh5 days ago
Mar 15, 20267334 views
Confidence Score0%
0%

Problem

So I have a spreadsheet with orders that I have organized into a pivot-table that shows the right things etc. Where there are currently column totals (summing all the rows before), I want to add something that says where the 20, 50, and 70th percentiles are in dollar terms. Additionally, for each o…

Error Output

=PERCENTRANK.EXC(relevant_range,grand_total_cell)

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: Percentile of order in excel pivot-table

Low Risk

@Soandos, I think you can add three new columns (with 20th, 50th and 70th percentile as headings) to your raw data to capture the 20th, 50th and 70th percentile calculation. Once this is achieved, manually refresh your pivot table to capture these n…

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment