可以读/计算枢轴表数据的差异吗？
嗨，堆栈溢出Hivemind ....我可以使用您的帮助。
我每周对几个客户进行销售报告，并通过Pivot Tables在一周 /一周的增长方面进行分析。这基本上是很多手动验证，而没有。我想知道....是否有一种编写代码的方法（无论是VBA还是Python还是SQL，还是您拥有的任何东西），这可能会为我读取数据，并最终在本周之间计算起伏很高（这是这样）持续一周，等等）？
即，告诉我本周与前一周之间的区别，只告诉我积极的动作，但是在某些方面仍然告诉我，无论如何它是上下的。如果那没有意义，我将尝试重新解释。
tldr-can i编写代码，该代码将分析枢轴表的几周之间的性能，这将为我计算起来是什么？ （按总数，然后这些百分比增加等等）？
Hi Stack Overflow Hivemind....I could use your help.
I do weekly reporting on sales for a couple clients, and do analysis on the week to week differences in growth with pivot tables. That's basically a lot of manually verifying and what not. I was wondering....is there a way to write code (whether vba or python or sql or whatever have you), that could possibly read the data for me and end up computing what the ups and downs are between the week (this week to last, etc)?
Ie, tell me the difference between this week to the week before, and tell me only the positive movements, but for some points still tell me whether it's up or down regardless. If that doesn't make sense, I'll try to re-explain.
tldr-Can i write code that will analyze performances between weeks for pivot tables, and that will compute for me what the ups and downs are? (By overall amounts, and then what those percentage increases are, etc)?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论