Marijn Bax Posted February 28, 2020 Posted February 28, 2020 I'm trying to calculate a weighted average over mutiple dimensions. see my attached worksheet in excel for some more explanation. I have tried usingWeightedAverage([Product Margin Abs],[Product Margin %]) over ([business unit],[Quarter],[Package Type]) but that does not seem to work.
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now