U
Utahstew
I use Excel 2002
I have a pivot table that is summarizing my product value on a dialy basis.
Categories include
Date Customer Product, Product Type Product Group Value
1/1/01 Dr. Hyde Hamburger Beef Meat
100
1/1/01 Dr. Hyde Brussel Spouts greens Veggie
100
I apply a tiered fee to a calculated item summarizing combined product
groups (ie all Fruit, all Veggies = F & V, meats, Dairy = M & D,etc). For F &
V there is a 5% for the first 10 dollars, 7% 11-30, etc.
If entire Order is greater than 100 then F&V tier one, tier two, tier three
If entire Order is less than 100 then F&V tier four, tier five, tier six
Is there a way for this to be automated ina pivot table?
I have a pivot table that is summarizing my product value on a dialy basis.
Categories include
Date Customer Product, Product Type Product Group Value
1/1/01 Dr. Hyde Hamburger Beef Meat
100
1/1/01 Dr. Hyde Brussel Spouts greens Veggie
100
I apply a tiered fee to a calculated item summarizing combined product
groups (ie all Fruit, all Veggies = F & V, meats, Dairy = M & D,etc). For F &
V there is a 5% for the first 10 dollars, 7% 11-30, etc.
If entire Order is greater than 100 then F&V tier one, tier two, tier three
If entire Order is less than 100 then F&V tier four, tier five, tier six
Is there a way for this to be automated ina pivot table?