Chart dimension interchange

[Anonymous]

Good morning everyone!

I have simple pivot table, let say as below.

Where Scenario is Dimension and 1Q14, ..4Q14 are Expressions

Scenario       1Q15    2Q15   3Q15   4Q15

BB                  3.0        3.5     2.4      3.7

BA                  5.2        2.6     3.9      2.8

FB                  1.9        4.5     3.5      3.1

FA                  5.2        2.6     3.9      2.8

FSA                1.9        4.5     3.5      3.1

With above example I have been getting Line chart as

Scenario on X axis and all Expressions values being displayed on Y axis as attachment.

But I want other way like 1Q15...4Q15 on X-axis. I tried changing dimension on Pivot side but unable to do so.

Is there any way without redefine dimension on Pivot?

Thanks for your time

[Clever_Anjos]

Are you using same object with fast change?

[Anonymous]

Yes

[Clever_Anjos · Accepted solution]

PFA

[Anonymous]

Hi Clever

Nice solution , still I am trying to figure out, did you merged?

Thanks a lot for effort

[Clever_Anjos]

1) Create your pivot table

2) Mark Fast Change for Pivot and Line

3) Click  "Line" type at presentation level and change the order of dimensions

[Anonymous]

Thanks for update

[Anonymous]

Hi Clever

I am unable to see below option at Presentation Tab, nor order option

3) Click  "Line" type at presentation level and change the order of dimensions

Btw, I have one dimension but multiple expressions

Could you elaborate please. Thanks

[Clever_Anjos]

Well, I´m going to play with your data, and try to find a solution

[Clever_Anjos]

Would you mind to show me 1Q15 expression?