4 ms·
Or, if you're fairly confident the pivot is fairly static and you just need to tack something on, then don't be afraid to do it if a custom calculation isn't so
by shostack 8y ago
Or, if you're fairly confident the pivot is fairly static and you just need to tack something on, then don't be afraid to do it if a custom calculation isn't solving it for you.
It surprises people but there's really no reason you can't do that if you just need it to work and/or look a certain way.
- function_seven 8y agoI 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.