Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Limiting Results in a Pivot Table
Hi,
have been looking in the online help and cannot find an answer to what I'm assuming should be a simple job; I have a pivot table showing countries A-Z in the Page Section, with Minutes (I work for a Telecoms co) in the Data Section. The Minute values range from 3 through 3 million. How can I limit the data to show, for example, only those Conutries that have more than 1 million minutes, or between 1 million & 2 million Many thanks in advance |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Limiting Results in a Pivot Table
Hi
One simple way would be to add an additional column to your table, tilled Group Set the formula in this column to be = INT(Minutes/1000000) Drag the Group filed to the Page area of the PT, (or the Row area) and use the dropdown to select just the Groups you want. -- Regards Roger Govier "pepperds" wrote in message ... Hi, have been looking in the online help and cannot find an answer to what I'm assuming should be a simple job; I have a pivot table showing countries A-Z in the Page Section, with Minutes (I work for a Telecoms co) in the Data Section. The Minute values range from 3 through 3 million. How can I limit the data to show, for example, only those Conutries that have more than 1 million minutes, or between 1 million & 2 million Many thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup on pivot table results = #N/A | Excel Worksheet Functions | |||
Can't ungroup in Pivot Table Results - or how do I get what i want | Excel Worksheet Functions | |||
how can i hide zero results row in a pivot table? | Excel Discussion (Misc queries) | |||
Reporting results of pivot table | Excel Worksheet Functions | |||
pivot table results - with value in every row and column | Excel Discussion (Misc queries) |