Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
balasundaram
Creator II
Creator II

I need expression for Current Financial Year vs Previous Financial Year in bar chart

Can you tell expression for Current Financial Year vs Previous Financial Year expressions in Barchart?

4 Replies
tresesco
MVP
MVP

sujeetsingh
Master III
Master III

You can assign a variable wich takes value as getcurrentselected Year or by default maxYear

Now you need to use two expression one with set analysis of current year and one with set analysis with curent year -1

engishfaque
Specialist III
Specialist III

Dear Balasun,

Kindly, find attached document.

Kind regards,

Ishfaque Ahmed

Not applicable

Dimension=Year


Expression

=Sum({$ <Year = {Year(today()), Year(today())-1}> }Sales)


I hvnt tested but it shall work