Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
may be like this:
IF(dimension = 'Value', Dimension)
and then check option "Suppress When value is Null" for this calculated dimension
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
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.
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