How to add calculated column based on values on pivot table


I’m looking to create a calculated column within a pivot table, which aggregates data on a daily basis (with the row representing Date). Specifically, I’d like to calculate a new column based on the values present in the pivot table. For instance, I’d like to compute the “Category1 %” by dividing the “Category 1” count by the “Total” count. For instance, for the first row, I’d want this calculated column to show the result of 45/54, which is approximately 0.83 or 83%.


Hi @kcaringal - please refer to the post below and let us know if it addresses your requirement:
With a pivot table of values, want to add a single % column


You can straight away use PercentofTotal Function like this,