Unable to create a Year on Year report running on Financial Year Date
we have been trying various ways to create a report that is run on the Australian Financial Year, JUL - JUN.
We are writing it in Cross Tab and have Cost Centres down the first left hand column. This is then followed by Month under which we have the costs for this year, then last year and the then the Variance between the two. Something like:
This Year. Last Year. Variance.
If we include the year in the columns Tab, then we get the month repeating for each year.
July AUG JUL AUG
This Year. Last Year. Variance. This Year. Last Year. Variance This Year. Last Year. Variance. This Year. Last Year. Variance
So not only do we get the comparisons under the month, the months are also repeated under each year.
If we remove the Year from the columns tab and also the join between the different views, then it shows correctly as far as no year at the top and no duplicated months. We are however, only able to show a January to December year where if the month are in the future, such as May and June now for 2018, it will show the figures for 2017/2016 butcompletely out of order as per the attached.
Is there a way around this?
Best regards Peter