Sep 27 2022 12:28 PM
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 that its driven from be affecting it?
Sep 27 2022 12:44 PM
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.
Sep 27 2022 12:55 PM
Sep 27 2022 01:02 PM
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?
Sep 27 2022 01:27 PM
Unfortunately doing the text to columns is affecting the formula I have in the column. I haven't seen that before.
Sep 27 2022 02:17 PM
Unfortunately that didn't work either. https://1drv.ms/x/s!Agmju254hK9cgkGIukISFqkfapby
Sep 27 2022 02:27 PM
Aug 01 2023 02:22 PM