Currently in Phocas if you need to compare sales against 2 financial year periods by month, you’re able to do this in Phocas by selecting the variance or period variance mode. However there are times when we need to compare against multiple financial years on a month-by-month basis, which is not possible under the current period variance mode options. You have to download each period separately into an Excel spreadsheet and manipulate your own data to create a graph.
The closest I can get to this is by mapping a custom dimension in the back end of the database and then setting up a custom mode to pull multiple FYs but this only works for bar charts only and not line graphs.
Will Phocas be implementing a way to compare multiple financial year periods by months for more than 2 time periods?
