| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
formulas in pivot table
How do you use a formula in a pivot table to calculate the % of two fields
that contain only words not numbers. Count of weeks as a % of A/T Fields: A/T Weeks Number A 24 Weeks 4 A 12 Weeks 5 A 12 Weeks 2 t 24 Weeks 1 t 24 Weeks 7 t 12 Weeks 4 t 13 Weeks 9 t 13 Weeks 2 t 13 Weeks 8 A 13 Weeks 15 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change Data In Pivot Table | New Users to Excel | |||
| Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
| Pivot Table Problems | Excel Discussion (Misc queries) | |||
| formulas referencing pivot table cells | Excel Worksheet Functions | |||
| Pivot table, how do you exclude counting cells with formulas as a | Excel Worksheet Functions | |||
Threaded Mode
