You are reading a single comment by @hugo7 and its replies.
Click here to read the full conversation.
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
@hugo7
EDIT: I've resolved it by deleting and re-doing the pivot on Sheet 2. I assume I must have used the wrong data somehow, even tho I'm positive I didn't.
Struggling with pivot tables. I've only really used these in LibreOffice Calc where I had no problems.
I have two sets of data; 1) all the data, and 2) a section of the data between two dates from 1).
My workbook setup is:
Sheet 1 = All the data
Sheet 2 = two pivot tables; i) money in, and ii) money out
Sheet 3 = the section of data between two dates which comes from Sheet 1 originally
Sheet 4 = two pivot tables; i) money in, and ii) money out
When I created the Sheet 4 pivot, it gave exactly the same readouts as Sheet 2 pivots, even though I'm highlighting from Sheet 3. I then refreshed it somehow and it gave the correct readouts, but now the Sheet 2 pivot is giving the Sheet 4 readout.
I'm totally baffled and can't actually think what key terms I need to be searching for are.
Any pointers?
Cheers.