Pivot chart

[#1]

i have pivot chart , have three dimensions :

year

Quarter

month

i change setting to fully expanded " but these three dimension are showing in three separate columns.

And i want to club them into one column only  (not three separate columns)

2013

     Q1

          Jan

          Feb

          March

     Q2

          April

          May

          June

like this

is it feasible???

[#2]

could you please share your sample application to understand your requirement..

[#3]

requirement is like this

[jagan]

Hi,

I think it is not possible exactly, check Indent Mode option in Style tab or select Data(Vertical) as Top in Presentation tab for all the dimensions.

Hope this helps you.

Regards,

jagan.

[ashfaq_haseeb]

HI,

That not directly possible.

1 work around could be.

Regards

ASHFAQ

[#6]

Hi gurjeet,

All three field in one column is not possible but adding some colors and hiding cell border you can change the look and feel of the table,and change the partial sum option from month to quarter which make more clear calculation.Hope this helps you

[jonathandienst]

Hi

This is not exactly what you are requesting but very close:

In the pivot table Chart Properties | Style dialog, check Indent Mode  and optionally check Use Only First Dimension Label. Now drag the column boundaries to something like this:

HTH

Jonathan

[#8]

hope this help you