| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Looking for pivot table functionality that shows detail instead of count
Here is a solution for multiple counts in a cell.
Assign a prime number to each ChildName (starting with 3) and use Product of ChildName. Then find the prime factors of the resulting Pivot Table product. For how to generate primes and find factors, search excel.worksheet.functions "How to find prime factors of a number" Nov 29, 2005 Lookup factors to get names and concatenate them. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell detail in pivot table | Excel Discussion (Misc queries) | |||
| Pivot table count function not counting all data. | Excel Discussion (Misc queries) | |||
| Using a Pivot Table Calculated Field to get a Unique Count | Excel Worksheet Functions | |||
| pivot table - subtotal below detail | Excel Discussion (Misc queries) | |||
| How do I get a pivot table to sum instead of giving me a count? | Excel Worksheet Functions | |||
Threaded Mode
