Expanding a Pivot chart

[#1]

Hello,

I need your help for manipulating a pivot chart.

My customer wants to expand a specific column which is unexpanded in pivot chart.

For example,

When I  try to expand  the value 'B'  of the  Area dimension in pivot chart. after selecting  a value('A')  of the  Area dimension in list box,  I can not expand the remaining values except the 'A' which was selected .

How can I expand the Area which is not selected in list box ?

Please refer to the attach files.

Regards,

WanKi,

[#2]

HI,

do you want to expand your a values when you click on a in list box

and want to expand only b values when you click on b in list box

and same for others too.

thanks

s shrivas

[consenit]

Hi there.

I believe the pivot table behavior you describe is by design.

Not sure about the possibility to achieve this using macros, though.

Kind regards,

Ernesto

[#4 · Accepted solution]

Hi Wanki,

Check you dimensions and remove the commented "//=if(WORKDATE=vl_SelWorkDate, AREA)" from dimension, it will work.

Regards,

Sajeevan

[#5]

Sudhanshu,

Yes, I want to expand all values, when I click the '+' sign, regardless of the value selected in the list box.

Thank you,

WanKi,

[padmanabhan_ram]

Hi Please see my attachment, it is getting expanded.

Is this you are looking for.

Thanks

Padmanabhan

[#7]

Ernesto,

I think so.

If there are no selection in list box,  I can expand the all values.

So, I am looking for the way , even it is  an alternative.

Thanks a lot,

WanKi,

[#8]

Sajeevan,

I got it,  thank you.

But, Why do you know that it is to be affected from the comments ?

Thank you very much ,

WanKi,

[#9]

Yes,  right !!

The problem is the comments in the dimension expression.

So I solved it.

Thank you,

WanKi,

[#10]

Hi Wanki,

I had a similar experience!

Thanks,

Sajeevan