Reply
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?

 

Cheers,


Hierosir