I'm trying to pull certain cells from a pivot and link into a table. Do you know if there's any way that I can do this without having to manually link each cell from my table into the corresponding one in the pivot? I can't set up look-ups because whenever I filter pivot, it throws off the looks ups. For instance, how can I have Feb-17 pull in from the same row that Jan-17 populated from without manually clicking on the cell from the pivot?
Jan-17 Feb-17 Mar-17 Apr-17 May-17 Jun-17 Jul-17 Aug-17 Sep-17
96,270 111,878 126,572 107,436 124,250 126,025 126,785 146,993 128,575
22,616
14,811
7,958
4,089
28,538
174,282 111,878 126,572 107,436 124,250 126,025 126,785 146,993 128,575
Bookmarks