我有一个带有列,年,周,市场,产品销售的表格。我的跑步总数应该是
我已经尝试了SQL脚本over(order by year, Week, Market, Product ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW)
。这仅适用于市场和产品组合的第一个记录集。随着市场和/或产品的变化,输出仍会考虑最近更新的数据进行计算。
Year Week Market Product Sale RunningTotal
2017 1 USA Shampoo 100 100
2017 2 USA Shampoo 100 200
2017 3 USA Shampoo 100 300
2017 1 USA Soap 100 400
2017 2 USA Soap 100 500
2017 3 USA Soap 100 600
2017 1 India Soap 200 800
2017 2 India Soap 200 1000
2017 3 India Soap 200 1200
我正在寻找的结果是这个
Year Week Market Product Sale RunningTotal
2017 1 USA Shampoo 100 100
2017 2 USA Shampoo 100 200
2017 3 USA Shampoo 100 300
2017 1 USA Soap 100 100
2017 2 USA Soap 100 200
2017 3 USA Soap 100 300
2017 1 India Soap 200 200
2017 2 India Soap 200 400
2017 3 India Soap 200 600
您需要按市场和产品划分:
OVER (
PARTITION BY Market, Product
ORDER BY year, Week
ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW
)
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句