Re:The pivot table, the spreadsheet's most powerful tool (2020)
by tqi on Monday October 09, 2023 @03:44PM
(#37824536)
> Kind of fine, but let’s hope there aren’t any new categories that weren’t there last month!
if it does mess up your formulas hopefully it does it in a way that you actually notice!
hyperbole aside, I don't think it's entirely Looker's fault that business users can't seem to get the hang of it, but I think the delta between what users "should use" and "actually use" is large enough that the tool just isn't worth it.
Especially since in my exp the most common way to do this is to paste the new data over previous sheet in an excel, and hope all the formulas still work.
Kind of fine, but let’s hope there aren’t any new categories that weren’t there last month!