Year calc

[Anonymous]

Probably an easy answer but it's not working for me.

If I have year on one chart 2013   2014  2015  2016  2017  2018  (Year req)

And I want to use that field for only 2014  2015  2016  2017 on another chart, how do I hide 2013 & 2018 on this chart?

Do I need to create another field, (Year req2)  or is there a way to manipulate the first field on the new chart?

[Anonymous]

Use

If(Wildmatch([Year req], '2013', '2018'), null(), [Year req])

as your chart dimension and uncheck 'Show null values' on the dimension.

Cheers,

Josefina

[Anonymous]

No this did not do it.  I want the field across the top to be 2014  2015  2016  2017( Year Rqstd), and for the bar chart to only reflect those bars.