Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
The site is not allowing me upload the image. I want to exclude the zero value in Bar Chart. Can anyone help in this regards?
CY - Sum({<Year = {'$(=Max(Year))'}>} Sales)
LY - Sum({<Year = {'$(=Max(Year)-1)'}>} Sales)
After applying
CY - if(Sum({<Year = {'$(=Max(Year))'}>} Sales)>0,Sum({<Year = {'$(=Max(Year))'}>} Sales))
LY - =if(Sum({<Year = {'$(=Max(Year)-1)'}>} Sales)>0,Sum({<Year = {'$(=Max(Year)-1)'}>} Sales),'')
Hi Ram
I hope this helps, I have a picture below.
I tried this for the first time . After that I used the third and fourth expression. Can you please go through the second image. It was done , but the space between 2015 and 2014 is high. Can anyone help in this regard?
You seem to have two dimensions and two expressions, is that right?
! dimension with 2 Measures, Sunny
HI Ram,
I dint get the use of if condition because your aggregated value will be greater than zero. So i doubt on working of if condition.
Can you share sample application?
Regards,
Partha K