02-08-2017 02:34 PM
I have a measure that is a TransactionAmount. I then have Financial Year Codes (FY14, FY15, FY16, FY17). I have a bar chart which will show the total sum of TransactionAmount for each Financial Year. Essentially showing total sales for each year.
I want to create a line to go across the graph which will show the average yearly sales. As the Chart does show the current financial years sales (still underway), I want to have this average calculated from all PRIOR financial years, not including the current (FY17).
How can I make this value?
Values in question here:
Chance for some help ?