Hello all,
I'm very new to Designer and currently trying to get my certification. I've been studying really hard and doing as many practice exercises as I can, and I'm teaching myself everything all by myself.
I was wondering if I would be able to get some assistance/advice/tips on a certain way to parse something.
Say I have a dataset that I need to find a specific thing out of a group of records - eg. an entire column of years for NYBS book titles, and one column has 30+ books in one year for each year. I'll attach images too to show.
Basically, I know what I need to do, but my method of going about it is clunky, time-consuming and not practical. I got the answer I needed, but I would love any advice on how to make this easier! I feel like I've tried every combination of Transpose, Cross-Tab and Summarize, but clearly there's something I'm missing/not understanding. I just want to understand what I'm doing wrong, why it's wrong, and better practices to go about it.
Thank you all in advance.
(For the image - I needed the highest grossing product from each year, so I used a bunch of filter tools to, well, filter out each year by itself, then a summarize on each of those to find the highest, then combined them all via the Union tool. )
