Pivot Chart Help - Conditions

[Anonymous]

Hello,

Looking for help on the Pivot Table dimension shown below

I am using the following calculated dimension:

=IF(YEAR < $(vBusinessYear) , YEAR & ' YE', YEAR & ' YTD' )

I would like to get rid of 2005-2007 on the graph as I only need >= 2008.  I am also looking to have this table static to always show each year, so I have YEAR =, in the set analysis.  Is there a way to change the calculated dimension or use the conditional setting? I have tried several options with no luck.

Thank you,

Justin

[sunny_talwar · Accepted solution]

Did you try this by any chance?

=If(YEAR >= 2008, IF(YEAR < $(vBusinessYear) , YEAR & ' YE', YEAR & ' YTD'))

Update: and ensure that you have suppressed the null value for the calculated dimension.

Best,

Sunny

[Anonymous]

I thought I had, but apparently I did not. 

Thanks for the help,

Justin

[sunny_talwar]

So did it work now?

Best,

Sunny

[Anonymous]

Sure does Sunny, thank you again.

[sunny_talwar]

Awesome!, glad to help.

Best,

Sunny