top x values

  1. I

    Top x historical chart dilemma

    Hello All, Have a question on how Excel creates charts. Input data: - Daily 'topics' with values. - Topics can vary daily. - Values can vary daily. I create a chart that shows ALL data from lets say January. - March 3rd, AND I choose the top 5 to view. My question is, at the bottom of the...
  2. D

    TOP 5 Items in Pivot by Dummy Values but hidden in Chart

    Hi Excel Expert, I noticed that the TOP X filter feature in pivot table will only work when the values are always different from one to another. Eg. If i chose TOP 5 Errcode in Case Stats Table in Jun 2017, the pivot table will populate and display 5 different Errcode with highest case count...
  3. S

    Pivot Table - Top 10 Based on Specific Column

    Hi there - My database is setup as follows as shown below. I am trying to FILTER the results to show TOP X based on TYPE, PROD2...not total sum of PROD2. Name....Type....Base ADV ABC......Prod 1....50 ABC......Prod 2....90 DEF......Prod 3.....20 GHI......Prod 1.....50 GHI......Prod 2.....70...
  4. C

    Array formula with top x results

    Hi, I need to use an array formula in Excel to summarise data from a table. The csv table is at the bottom of this posting. I want to summarise the top 5 clients (i.e. excludes Administration in Type field) where the hours are greater than zero and Invoiced is zero. My summary should look...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top