Pivot Chart - Dimension Expression Header/Level Change & Sorting

[#1]

Hello There!

I need a solution for to change the Dimension Expression Header/Level for Pivot Chart and as well as Sorting the Dimension Expression as per the Value. How can I achieve that?

I'm posting here a snap-shot of my current Pivot Chart for your ready reference and suggestion.

Thanks in Advance.

Sajjad Ali.

[pokassov · Accepted solution]

Hi!

[#3]

Hello!

Thanks for your suggestion/solution.... Actually I found the Level check-box was dimmed (Disabled); however it works fine.

Can you please suggest regarding 'Sorting the Dimension Expression as per the Value. How can I achieve that?'

Thanks & Regards,

Sajjad.

[pokassov]

1. Tab "Sort"

2. Select Dimension that you want to sort

3. Check box "Expression"

4. Put you expression there

5. Uncheck boxes "Numeric Value",'Text'