how to get even years on chart

[Anonymous]

i have a table in 2001 ,2002,2003,-------------2010  years

i want to 2002,2004,2006,2008 display on barchart.

dimension-->year

exp-->sales

[tresesco]

Try using calculated dimension:

Dimension: =If(Even(Year), Year)

[jayshrinipurte]

Hi Chandu,

May be this will help you in your dimension,

if(Even(Year),Year)

Regards,

Jayshri

[Anonymous]

i try this,it shows total sales

[tresesco]

Could you share your sample qvw?

[jayshrinipurte]

[Anonymous]

thanks,its working

[jayshrinipurte]

Close this discussion by marking as correct or helpful.