Forum Discussion
danielboi
Helper I
4 years agoCalculating FX / currency Variation in Sales Report
Hello community, I want to calulate sales price variations, which is a comparison of budget price, budget volume and actual price, actual volume. It starts with eliminating currency effects. ...
- 4 years ago
OK, managed to solve it on my own.
Since I am doing the model also in Excel I am cannot use bi-directional filtering. Of course I tried using crossfilter, it did not work. Over night I got the epiphany how to properly use crossfilter. Issue is solved!
danielboi
Helper I
4 years agoOK, managed to solve it on my own.
Since I am doing the model also in Excel I am cannot use bi-directional filtering. Of course I tried using crossfilter, it did not work. Over night I got the epiphany how to properly use crossfilter. Issue is solved!