How to restrict values with in a dimension in the chart itself

[khigaurav999]

Hi Folks,

I have the below bar chart, In the report month dimension here I want it to show values that are greater than March 2017 (> March 2017). How can I achieve that?

FYI I tried standard dimension limit chart property options that don't seem to work and server the purpose. Also, limiting data in load script thru where clause is not working or not an option here for me.

Thanks,

Gaurav

[fvelascog72]

Hi,

Have you tried with Set Analysis?

Saludos.

[shiveshsingh]

Try like this in dimension

=if(date(date#([Report Month],'MMMMM YYYY'),'MMMMM YYYY')> 'March 2017', [Report Month])

[khigaurav999]

No not yet.

[Anonymous]

Use the Calculated Dimension option and try below in Dimension definition :

=if(date(date#([Report Month],'MMMMM YYYY'),'MMMMM YYYY')> 'March 2017', [Report Month])