conditional dimension

[neha_sri]

I have a chart where I have dimension as week num (i.e Week-,Week-1,Week-2,Week-3 ..and so on) I want to remove Week-, so that my dimension should start like (Week-1,Week-2... and so on).How can I do so..

Thanks in anticipation

[tresesco]

Try like:

If([Week Num]<>'Week-', [Week Num])

And check 'Supress When Value is Null' in dimension tab.

[PrashantSangle]

Hi,

Try like

If(not isnull(Subfield(DimensionName,'-',2)),DimensionName)

OR

If(len(trim(Subfield(DimensionName,'-',2)))>0,DimensionName)

Regards

[#4]

use set analysis

        expression is like this

             sum({<week={'*'}-{'week-'}>}dimension) i hope this will help u

[#5]

Hi,

Give the dimension as

If(Week num='Week-',null(),week num)

Then Supress Zero values

Regards,

Joshmi

[CELAMBARASAN]

You could use dimension

If(WeekNum<>'Week-', WeekNum)

Also you can do with set analysis, Assuming that you have expression as Sum(Sales) then

Sum({$-<WeekNum={'Week-'}>} Sales)

But I wonder how it formed without number. I would recommend to remove that value from the WeekNum Field itself.

Thanks

Celambarasan

[neha_sri]

actually I dont want to suppress the 0 value and again i have cyclic drill down in dimension which has one field as Week Num and other dimension as Month