Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to exclude an object (line chart) from a selection (i.e. the year). If the year is 2013 or earlier then I use static data, if the year is 2013 or later the variable is calculated by cost divided by number of FTEs. Regardless of the year selected, I want to see all the years in the line chart.
if(year<2013, |
(ALT( sum({1}{ <Year= >}[TCO per fte]), 0) ),
(ALT( sum({ <Jaar = >} Total cost part A, 0) + (ALT( sum({ <Jaar = >} (Total costs part B)))))
/
ALT( sum({ <Year= >} ([Total fte]))))
Just add the second set of criteria using another if() statement:
if(year<2013,
(ALT( sum({1}{ <Year= >}[TCO per fte]), 0) ),
if(year>=2013
(ALT( sum({1}{ <Jaar = >} Total cost part A, 0) + (ALT( sum({ <Jaar = >} (Total costs part B)))))
/
ALT( sum({1}{ <Year= >} ([Total fte]))))
)
unfortunately; this isn't working. If I make a selection on "year" this still has an effect on the chartline. Only selected years are shown, and I wanted to see all years.
if(Year<2013, |
(ALT( sum({1}{ <Year= >}[TCO per fte]), 0) ),
if(Year>=2013,
(ALT( sum({1}{ <Year= >} Total cost part A), 0) + (ALT( sum({1}{ <Year= >} (Total cost part B)))))
/
ALT( sum({1}{ <Year= >} ([Total fte])))))