Forum Discussion
Calculate previous month Sales in Virtual Table
Hi lbendlin ,
Thank you for your reply,
So each period (PER-X) has the 12 month in each on my real data. Here there are just 3 periods and months to simplify the test.
If the user picks a period, I want to see the sales for each month of that period, but also the sales on the previous month, so I can then compare both. I'm calculating a virtual table because once I have this step done, I'll add some Exchange ratios and other calculations.
Right now I can see correctly the Forecast, in the Test table and in the visual matrix, but the Actual appears correct in the test table but it appears the total amount in each month, instead of getting splitted.
Maybe the approach I'm doing to get this calculation done is not correct and I can do it in a different way, but I'm not sure how.
Thank you very much for helping.
Super UserThink about the sustainability of your process. If you think it is low maintenance then keep using it. But if it is a hassle to set up and you have to constantly change stuff around (now month, new year etc) then it may be worth considering a refactoring. Try to use generally agreed terminology (ie don't mix up actuals and forecast - they have different meaning. Even the word "forecast" it self is rather ambiguous.)
See if you can run all this on measures, without the need for the extra table.