This post has been de-listed
It is no longer included in search results and normal feeds (front page, hot posts, subreddit posts, etc). It remains visible only via the author's post history.
So the problem I'm having is that although I'm very familiar with pivot tables, I'm not experienced with get pivot data.
On the main page of a report, I see a section which has a =GETPIVOTDATA function. First argument is "Sum of Total Candidates Cleared to Start", second is "Pivot B". I can't figure out where exactly this is pulling from and therefore whether I need to update anything.
The second argument is Pivot B, and there's a tab called that, so I guess it's somewhere from there. But the tab Pivot B has 3 diff pivot tables there so I don't know which one it's pulling from.
Please help!
Subreddit
Post Details
- Posted
- 1 year ago
- Reddit URL
- View post on reddit.com
- External URL
- reddit.com/r/excel/comme...