Hi Chris, Thanks for the explanation - helped me a lot! BUT in one of the XLS files I am getting warning message "AutoSort and SutoShow can't be used with custom calculations that use positional references". If I say YES, then the data just goes haywire. Can you provide some insight into this issue and how to get around it ?
Chris I have followed your year-over-year and that area it really isn’t suitable for what I would need. I’m more interested in doing a family budget and I’ve been doing it for a great number of years. I have a table with the different family costs listed in the rows. The columns are all of the years. I have slicers off for the years and the costs. In your example you have every other year or call them and I have a Costco run and I’d like to maintain the cost column type rather than the listing of yours the way you did can you or can you tell me how I can make the year over a year table for say 2122 or 20 to the same example that you have in your lesson
2:38 "This is the cool part of this video." All I needed to see was this 20 seconds and I got it. Super easy -- Thanks!
Chris's way is the easy way! Thank YOU!
You bet!
Exactly what I needed - better way than I had been doing previously
Thank you!
exactly what I was looking for! thanks!
Glad I could help!
Thank you 👍
You are welcome
best
Thank you!
Hi Chris, Thanks for the explanation - helped me a lot!
BUT in one of the XLS files I am getting warning message "AutoSort and SutoShow can't be used with custom calculations that use positional references". If I say YES, then the data just goes haywire. Can you provide some insight into this issue and how to get around it ?
Same issue here as well.
Hi Chris, In my PivotTable Fields list I don't see a "views" option. How does this show?
Chris I have followed your year-over-year and that area it really isn’t suitable for what I would need. I’m more interested in doing a family budget and I’ve been doing it for a great number of years. I have a table with the different family costs listed in the rows. The columns are all of the years. I have slicers off for the years and the costs. In your example you have every other year or call them and I have a Costco run and I’d like to maintain the cost column type rather than the listing of yours the way you did can you or can you tell me how I can make the year over a year table for say 2122 or 20 to the same example that you have in your lesson