is there a way to force a pivot table to display the values in grouped fields?..
for example, I have the management lead as my first pivot column..row one has that person's name...row 2 (which also belongs to the same mgmt lead) is blank...I would like the table to display the person's name in each row....
I am importing this excel into the gnatt chart'er in visio...so the values are 'blank' in the gantt chart for each 'grouped' value....
for example, I have the management lead as my first pivot column..row one has that person's name...row 2 (which also belongs to the same mgmt lead) is blank...I would like the table to display the person's name in each row....
I am importing this excel into the gnatt chart'er in visio...so the values are 'blank' in the gantt chart for each 'grouped' value....