J jcheko Feb 16, 2010 #1 how can I get my pivot table to show the value in a cell not the count?....(the actual data of the cell)...thanks
how can I get my pivot table to show the value in a cell not the count?....(the actual data of the cell)...thanks
J JH Feb 16, 2010 #2 To begin, you need to make sure the cell type is number, not text then, you can change the summation by right click the field in the pivot table layout, and change it to Sum instead of Count JH
To begin, you need to make sure the cell type is number, not text then, you can change the summation by right click the field in the pivot table layout, and change it to Sum instead of Count JH
