Hello,
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%.
