Forum Discussion
Pivot Table - Field Value is 1
Hi All, Can someone point me in the direction to resolve this? I need the value field to match the numbers in the LPH column but it's defaulting to a "1" in the pivot table. Would a formula tha...
Click anywhere in the pivottable.
Click on the Count of LPH field in the Values area of the PivotTable Fields task pane.
Select Value Field Settings from the drop down menu.
Change the summary function from Count to Sum.
Click OK.
Select the LPH column.
Set the number format to General or Number.
On the Data tab of the ribbon, click Text to Columns, then click Finish.
Switch to the pivottable and refresh it.
Can you now set the summary function to Sum?
Unfortunately doing the text to columns is affecting the formula I have in the column. I haven't seen that before.
