Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count(s) in Pivot Table
I have listing of 1600 stores and sales by 4 week periods. I have a helper
cell to combine the state and city since this is one basically how I want the date to break. But there may be say 15 unique stores in Atlanta, my pivot shows the correct total sales for Atlanta but in the "count" I am getting instead of 15 I expect it is counting the each store in each period (15 stores x 12 periods=180). in the pivot I want the state, city total sales, unique stores (making up the total) so that it would it would look like: GA: Atlanta 5000 (sales) 15(unique stores) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count(s) in Pivot Table
It is counting the number of records that have a value for stores not a
unique count of the stores. Check out this link... http://www.contextures.com/xlPivot07.html#Unique -- HTH... Jim Thomlinson "Reno" wrote: I have listing of 1600 stores and sales by 4 week periods. I have a helper cell to combine the state and city since this is one basically how I want the date to break. But there may be say 15 unique stores in Atlanta, my pivot shows the correct total sales for Atlanta but in the "count" I am getting instead of 15 I expect it is counting the each store in each period (15 stores x 12 periods=180). in the pivot I want the state, city total sales, unique stores (making up the total) so that it would it would look like: GA: Atlanta 5000 (sales) 15(unique stores) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count(s) in Pivot Table
Excel 2007 PivotTable
Count unique stores. With and without formulas. http://www.mediafire.com/file/rzy4vmjtwnk/01_11_10.xlsx |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count(s) in Pivot Table
"Herbert Seidenberg" wrote: Excel 2007 PivotTable Count unique stores. With and without formulas. http://www.mediafire.com/file/rzy4vmjtwnk/01_11_10.xlsx . i beleive this will do it, but i don't see how to Insert Calculated Field, it does not appear on the Insert Ribbon, my ignorance is stunning. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count(s) in Pivot Table
Excel 2007 PivotTable
Count unique. Added more pictures. http://c0444202.cdn.cloudfiles.racks.../01_11_10.xlsx |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Count | Excel Discussion (Misc queries) | |||
Pivot Table Sum vs Count | Excel Discussion (Misc queries) | |||
Pivot Table - Count If | Excel Discussion (Misc queries) | |||
Pivot Table Count | Excel Discussion (Misc queries) | |||
Count within pivot table | Excel Worksheet Functions |