Wondering if someone can help me with my pivot table data not totally matching my original sheet the pivot table data is coming from.
My original sheet capturing data from Google analytics and updating every 24 hours:
My duplicate sheet adding the pivot column
My pivot table, used for condensing the rowIDs from different pathways into 1 row each to create sums and averages in order to displays rankings “top ten lists”
I originally thought my pivot table just wasn’t updating after it was created but some of the numbers at the top of the sheet are correct. Other numbers for individual profiles aren’t adding up right.
EXAMPLE:
The collective sum of my profile views from the original sheet is 50 views
However the SUM on the pivot table of my views is 39.
Any idea what could be causing this??