Parallax Demon has won 6,073 Achievements and 163 Challenges in 153 games and 2 apps
Registered on 08 Apr 10
| Last visited Today | Last scanned today at 19:42 by TA Scanner 1
Its almost 1000!!
Spare columns here: - https://farm4.static.flickr.com/3125/3163231156_909c6a0....jpg
11 other comments
maybe make a column for notes on the original data to be used when you drill down in the pivot? Or make a new column after? The pivots can change, so notes on the pivot
wouldn't work well.
THAT DID NOT HELP BEAN
yeah i think i have to add it to the original table, but hopefully i can add the notes once it is in the pivot table itself
Adding it to the original data may not work if the pivot is summarizing multiple items (as you'd expect). Add a notes column but also a second for a reference that
matches the lines in the first column of the pivot. (So If you have Monday, Tuesday etc. in row A of the Pivot, data in row B, Notes row C and reference Row D)
The reference row is then =A3 (Monday), =A2 (Tuesday) etc. Then before you refresh the Pivot copy paste special Row D So when the pivot changes you then then lookup Row D
Using Vlookup or index and match and your notes will move to whatever line they now are on in the pivot. It's a clunky solution but works fine for small data sets.
Will you be changing the original data? If not, just copy the pivot table and paste the values somewhere else. Add whatever you want.
I might look into what Ark is suggesting. I don't want to change the data in the pivot table, but I am sorting several thousand rows of data by one set of paramaters (wh
(which I want the notes associated with) and filtering by date.
Know the feeling
That meme is like two days old
45 achievements out of 55 won | 83,757 tracked gamers have this game | Last played 24 May 18
135 achievements out of 148 won | 71,044 tracked gamers have this game | Last played 21 May 18
30 achievements out of 30 won | 10,101 tracked gamers have this game | Last played 19 May 18
| Given 4 stars by Parallax Demon
Copyright © 2018 TrueGaming Network
Ltd, All Rights Reserved
Xbox, Xbox Live, and all other Xbox Live specific terms are registered trademarks of Microsoft Corp.
TrueAchievements is a proud member of the Xbox Community Developer Program
Concept, Design, Programming and Server Stuff by Rich Stone
Site version: 5.1.3, also available on Mobile