Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I want to show data in Bar chart conditionally for instance
1. take year in Listbox
2. take bar chart with x axis is year and y axis is sales.
I want to display Bar chart with current year data by default and rest of years based selections. (Current year is static and rest of years dynamic).
Thanks,
Nihhal.
Hi,
May be like this (look attached file)
Sum ({<Year=Year+{2017}>}Sale)
Regards,
Andrey
May be this?
If(GetFieldSelections(Year) = 0, Sum({<Year = {'$(=Max(Year))'}>} Sales), Sum(Sales))
Hi Anil - Its not working.
Hi,
May be like this (look attached file)
Sum ({<Year=Year+{2017}>}Sale)
Regards,
Andrey