Frequent Visitor
Posts: 3
Registered: ‎02-08-2017

Calculate and plot an Average from sales per year

Hi guys!


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:


Table: viw_rprt_transactions

Measure: TransactionAmount

Column: FinYear_Code


Chance for some help Smiley Very Happy?