Show data in Bar chart conditionally

[nihhalmca]

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.

[Anil_Babu_Samineni]

May be this?

If(GetFieldSelections(Year) = 0, Sum({<Year = {'$(=Max(Year))'}>} Sales), Sum(Sales))

[nihhalmca]

Hi Anil - Its not working.

[ahaahaaha · Accepted solution]

Hi,

May be like this (look attached file)

Sum ({<Year=Year+{2017}>}Sale)

Regards,

Andrey