|
|
#2
08-23-2017, 10:21 AM
|
||||
|
||||
Perhaps you can add a helper column to the main data with formula like:
=IF(F2="",0,F2) Where F2 is first Content_Completed column entry. Copy formula down. Put a header title in the column and use that column in the Pivot table instead. 
|
| Tags |
| averages, default values, pivot tables |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 How do I create a report that works like a pivot table but does not calculate values
|
elizbeth6339 | Excel | 1 | 03-09-2016 07:14 AM |
| How to create a pivot table with text as values | ljd108 | Excel Programming | 0 | 01-22-2015 07:48 PM |
| Pivot table auto print. For multiple values. | Nicholaspoe | Excel | 0 | 10-08-2013 09:08 PM |
| Pivot Table:delete zero values when using calculated objects | Serge 007 | Excel | 1 | 06-05-2013 11:47 AM |
|
add values from different variables with pivot table
|
andrei | Excel | 2 | 01-19-2012 08:45 AM |
Windows 10 
Office 2013
Threaded Mode