Populate column rows with column Total

[#1]

Hi,

I'm working with a pivot table and need to populate the every row in a column with the columns sum. I've tried using the TOTAL function, but this totals across all dimensions in the pivot table. I've tried aggregating by my dimension of interest, and although this works, the total's only shown at the top of the table, not in each cell of the column.

I've attached an app to better illustrate the issue.

Any advice would be great.

Thanks,

Matt

[Clever_Anjos · Accepted solution]

You can restrict what kind of "TOTAL" you want

Sum(TOTAL <Template> Traffic) respects Template

Sum(TOTAL <Template,Day> Traffic) respects Template and Day

[#3]

Thanks! Much appreciated.