Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi People
I have a requirement to build bar chart with sales of selected year and less than selected year.
I have used this expression to show previous year data,
=Sum({$<acc_period_year={"<acc_period_year"}>}bill_size)
But the expression gives null values. Please help me correct the expression.
Thanks
Balaji
Try This
Sum({< acc_period_year = {"<=$(=max(acc_period_year)-1)"}>} bill_size)
regards
An Pham
May be try this,
Sum({< acc_period_year = {"$(=max(acc_period_year)-1)"}>} bill_size)
Thanks for the reply aparna.
your expression gives me sales value of only the previous year. But i want to display sales value of all the years below the selected year.
For that you can just subtract the max year by -2 for getting previous year sales
Try This
Sum({< acc_period_year = {"<=$(=max(acc_period_year)-1)"}>} bill_size)
regards
An Pham
try this below:
Sum( {< acc_period_year = {"<$(=max(acc_period_year))"}>} bill_size)