I want to divide an amount of a cell (for example, a certain month’s value) with the total amount of the column (for example, all year). how do I do it?
have you tried the table calculation options on the pivot table, it lets you calculate running table, % of total, rank, percentile etc. You can select the measure from the value field well of the pivot table, select the drop down and then select the “Add table calculation” option. see attached screenshot