Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a chart below that compares 2016 and 2017 values. How do I limit the months that are shown, so that those months without comparison (i.e., November and December) are not shown? You can see below that there is not yet 2017 data for November or December, so I don't want to include these until data is populated. Is there a dynamic way to do so? So that when November data pulls in, we can see the previous year's data come back into view?
Hi Claire,
You could try using a calculated dimension.
First set up a new variable to hold current year
vCurrentYear = YEAR(TODAY())
Your calculated dimension.
=IF(SUM({<Year={$(vCurrentYear)>}}VALUE) <> 0, Month).
Mark