To show dimensions on graph like on Pivot

[innashna]

Hello,

I have a Report which looks like in the attached .

I need to make it like in Pivot chart - 'Central Division' should appear one time for all its Regions and not two times. Is it possible?

[rubenmarin]

Hi, if this will be a pivot table Central division should only be shown one time, when you expand the dimension, both regions will be show in the next column. Is it not showing that way?

[innashna]

Hi,

I need to show this in bars graph, not table.

[rubenmarin]

Hi, ok, now i see why it's difficult. I have played a bit with options and made a custom table to work with region indexes instead of values, so it didn't show all regions for every division (not just the regions of each division).

So dimension is the index but is hiden, another expression with text in axis show the region names. 

Still I couldn't remove the extra space it gives in the axis, anyway, I'm not sure if this approach can work with your real data so I didn't keep trying.