'Function does not auto-fill properly in Pivot Table

I would like to add an additional column to an existing pivot table in Excel, which refers to the other columns in the existing Pivot Table, but it seems like the function is not auto-filling properly as I drag the cell down, rather it uses the same value as the first row. Is there a way to apply function auto-fill in Pivot Table?



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source