| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
"Other" category in Excel
I work for a translation company and work a lot in pivot tables to display
our top spend by target language (German, French, etc.). I would like to use a pivot table that displays my top 10 languages with an "OTHER LANGUAGES" category with the spend for all the remaining languages. If I filter the top 10 languages in the pivot table, the others disappear completely from the report. So I have one unfiltered pivot table, and another table that references the 1st with an "OTHER LANGUAGES" category that I created manually. But is there any way to create an "OTHER" category automatically within the pivot table? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
| Getting a category x-axis to sort of "right-justify" | Charts and Charting in Excel | |||
| In a bar chart, how do I change the x-axis "category" labels? | Excel Discussion (Misc queries) | |||
| UDF Add-in New category in "Paste Function Dialog Box" | Excel Worksheet Functions | |||
Threaded Mode
