3 ms·
I often end up doing that, but it feels “dirty”, you know? And I also underestimate how long-lived my report will be, and get stuck having to move those sideli
by function_seven 8y ago
I often end up doing that, but it feels “dirty”, you know?
And I also underestimate how long-lived my report will be, and get stuck having to move those sideline calculations out of the way when I need to refresh the pivot (“This will overwrite existing data.”)
Which brings up another gripe: why can’t the Pivot allow me to push those rows or columns down/over instead of clobbering them?
- shostack 8y agoIt absolutely feels dirty. Every. Single. Time. It has likewise bitten me more than once when I formatted everything identically, but then forgot that I had tacked something on that isn't updating. And yeah, one feature on my wishlist would be "It looks like you're about to overwrite a ton of data! Rather than make you cut/paste it elsewhere, how about we just shift them!" There's probably some repercussions I'm not considering for why that is problematic, but its a problem worth solving.