Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You can restrict what kind of "TOTAL" you want
Sum(TOTAL <Template> Traffic) respects Template
Sum(TOTAL <Template,Day> Traffic) respects Template and Day
You can restrict what kind of "TOTAL" you want
Sum(TOTAL <Template> Traffic) respects Template
Sum(TOTAL <Template,Day> Traffic) respects Template and Day
Thanks! Much appreciated.