Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table - grouping with formulas
I use a pivot table that is linked to data which I update weekly.
One of the fields I have is customer age. This is the number of products a customer has bought from us in the past. If a customer has only bought one product in the past, we call them sensitive. If a customer has bought two products, he is semi-sensitive. If they have bought 3 or more, we call them firm. These 3 categories of customer ages we call Customer Sensitivity. The customer age field in my data runs from 1 to 90. I use the group function in the pivot table to group all sub ages from 3 to 90 and call them Firm. This is where my problem begins. If, on the following week, we now have a customer with a new age 91. I now need to ungroup my Customer Sensitivity and regoup the firms to include age 91. Is it possible to use the formulas - calculated field or calculated item - to enter something along the lines of...(if customer age2, 'Firm', (if customer age=2, 'Semi-sensitive','Sensitive')) or something like that! Many thanks in advance for any advice. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table grouping of data | Excel Discussion (Misc queries) | |||
Grouping in Pivot Table | Excel Worksheet Functions | |||
How do you create formulas in pivot table eg simple division? | Excel Worksheet Functions | |||
pivot table created from another pivot table | Excel Worksheet Functions | |||
pivot table sort entries that don't yet appear in table | Excel Discussion (Misc queries) |