Accumulative sales with multiple criteria

[richard.lim85]

HI excel experts

In need help to find out what is the best formula for accumulative sales with multiple criteria, by distributor code, by product. if possible i want to add more criteria in the future

I have put the Accumulative sales column as example

THank You

SIncerely,
Richard

[FDibbins]

Try this, copied down...
=SUMIFS($E$2:E2,$A$2:A2,A2,$B$2:B2,B2,$C$2:C2,C2)

If you follow the logic, you should be able to add more criteria if needed.

[richard.lim85]

Thank You so much, i did not know Sumif formula can do $E$2:E2

[FDibbins]

Yup, you absolute the 1st cell to anchor it, so when you copy down, the 2nd part increases, but the anchor stays there.

Also note that I used sumifS(), not sumif()

[richard.lim85]

What about MDX Calculated Measurement under OLAP Tools, my excel connected to a database, it only allows to use OLAP Tools > MDX Calculated Measurement to add customize measurements
What is the Accumulative formula using MDX?

[FDibbins]

I dont use MDX or OLAP tools, so cant help you there,

[richard.lim85]

Thanks for the reply, Do you know power BI formula for this Accumulative sales with multiple criteria?

I understand the formula is not straight forward for Power BI, but need advise for this, i have been trying for weeks but no promising result so far