Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am using below formula but for trend it's bifurcating max year value, not giving correct trend for all financial year
Sum({<fyear>}sales)
/
Sum( {<fyear>}total sales)
Hi
try
Sum({<fyear=max(fyear)>}sales)
/
Sum( total sales)
or
Sum({<fyear=max(fyear)>}sales)
/
Sum( Allsales)
Hope this helps
Thanks