Custom Columns in Pivot Table

Can we create custom columns in a pivot table?

Yes @keerthana.kalimuthu,

We can generate custom columns in a pivot table using the following steps:

Step 1: Start by selecting the Explore icon within the insight where you want to generate a Calculated Column.

Step 2: Select the Pivot Table option and navigate to the Fields options within the Pivot Settings.

Step 3: When you select the Fields option, it will open the Fields tab, allowing you to choose Add calculated value.

Step 4: In the Calculated value tab, assign a name to your Calculated Column. Use the comprehensive list of columns, aggregation options, column types, operators and functions to construct your formula. Drag and drop the desired columns into the formula box.

Step 5: Once your formulation is complete, click on the Apply button, to see the generated Calculated Column.

For a comprehensive explanation, Click Here