setting a fixed value for a dimension rather than in all expressions

[#1]

Hi,

I'd like to know if there is a way to set a fixed value to my main dimension in a pivot chart instead of doing it in all expressions.

I've cloned a pivot chart to get an insight on a specific value of the main dimension. As my chart has about 15 expressions and I need to go trought all the sheets without specific selections, it would be nice if I can edit the chart's main dimension with the right value.

I tried to edit the dimension the same way as in expressions ( {<dimension = {'value'}>} but it doesn't work

Thanks for your answers ans tips

Julien

[sparur]

may be like this:

IF(dimension = 'Value', Dimension)

and then check option "Suppress When value is Null" for this calculated dimension

[#3]

Hi Anatoly,

Thanks for your advice.

It partially works : my chart just naturally shows datas for this value. But I got a new problem : if I select another value for that common dimension across my document, then my chart fall down.

The IF condition depends on the selection. Do you know if there is anything like "{1}" I can add to force the chart to always show the datas for that set dimension value ?

Cheers,

Julien

[sparur]

I can to advice you - to use a variable instead of Value. for example:

Calc dimension: IF(Customer = $(vCurrentCustomer), Customer)

variable vCurrentCustomer = Only(Customer).

so when you will be select one value in Customer field, your variable will be change. so your chart will be change too.

[#5]

I tried this new way but I probably have a syntax error.

My main dimension is the field "domainsupport_label". Included in that field is the value "autopromo_biz" (the one I want to set for the whole chart).

I wrote that for that dimension : if(domainsupport_label = $(vSupport), domainsupport_label)

vsupport = Only ('autopromo_biz') => generate a mistake

vsupport = Only(domainsupport_label = 'autopromo_biz') =>generate mistake

Don't know where is the mistake...

Cheers, Julien