Representing Differences in Sales Through Time

Hows this to get you started ....

The trick is in the Filtered Values Formula that the philanthropy folks use allot.  My Fiscal Current Year Offset is from the Performance Date Section.
For each [Fiscal Current Year Offset2] select a value from 0 for 2020, -1 for 2019 etc.  

• ( [Total Ticket Paid Amount] , [Fiscal Current Year Offset1] ) - ( [Total Ticket Paid Amount] , [Fiscal Current Year Offset2] )
  
  

I added a zazzy red if it's minus and green if it's plus colour.  I've also done it by Theatre which is a kind of cheat.

Cheers,

RosannaPerillo.dash

Hey Heath, do you know how to use the DiffPastYear formula? I am trying to use it to create a visual representation of the variance in sales over the years but it's not returning me any value.. 

Here you go

the formula is either ...

• DiffPastYear  (  SUM [Ticket Paid Count]  )  OR
• DiffPastYear  (  [Total Ticket Paid Count]  )

They mean the same and depends on where you are as to which comes out

RosannaPerillo2.dash

Here you go

the formula is either ...

• DiffPastYear  (  SUM [Ticket Paid Count]  )  OR
• DiffPastYear  (  [Total Ticket Paid Count]  )

They mean the same and depends on where you are as to which comes out

RosannaPerillo2.dash

Thank you Heath!!