Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table and value range
Hi,
I have built a simple pivot table with 2 columns : Amounts and count of amounts eg: amount/Nb of amount 100 /1 150 /5 200 /6 250 /2 300 /1 450 /5 500 /9 Would it be possible to have a range of value in the pivot table to have a result like this: amount/Nb 0-200 /12 201-400 /3 401 /14 Thank you for your help Thank you |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table and value range
I would add a column to the raw data that categorized the amounts.
if(a2<=200,200,if(a2<=400,400,"400+")) Then drag this down the data. And use it as the field in the pivottable. Nicawette wrote: Hi, I have built a simple pivot table with 2 columns : Amounts and count of amounts eg: amount/Nb of amount 100 /1 150 /5 200 /6 250 /2 300 /1 450 /5 500 /9 Would it be possible to have a range of value in the pivot table to have a result like this: amount/Nb 0-200 /12 201-400 /3 401 /14 Thank you for your help Thank you -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table and value range
Thank you for the answer, excel 2007 is providing a tool to do it
easily under pivot table tools, option, group selection. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table as Source Range | Excel Discussion (Misc queries) | |||
Pivot Table Range | Excel Worksheet Functions | |||
Dynamic Range in a Pivot Table | Excel Discussion (Misc queries) | |||
Multiple Range Pivot Table | Excel Worksheet Functions | |||
Setting Range in Pivot Table | Charts and Charting in Excel |