Switching expressions and dimensions in chart

[Anonymous]

Hello everyone!

i suspect it must be an easy thing to do but I am kind of stuck here. I would like to know if it is possible to switch expressions and dimensions in a stacked bar chart. This is what i am trying to do:

	2014	2016	2017	2018
a	400	100	250	0
b	0	0	300	150
c	150	0	600	50
d	600	260	150	0
e	0	150	150	0

Thanks in advance!

emin

[buzzy996]

create a either cycle/drill down group and use the same group as ur dimension.

that helps to change the dimension dynamically.

[buzzy996]

fyi,how to do.

[Mark_Little]

Hi,

As mentioned a cyclic group will let you change the dimensions.

But you could used conditional option.

The either use a data island and a selector like

LOAD * INLINE [

    Option

     Expression1

     Expression2

];

The an option as a selector

Then the conditon would something like

=GetFieldSelections(Option) = 'Expression1'

Mark

[Anonymous]

Thanks everyone for responses! However I should have been more precise. I don't have years as dimensions. Actually this is how my data looks like:

	2015 H1	2015 H2	2016 H1	2016 H2	2017 H1	2017 H2	2018 H1	2018 H2
a	150	250	30	70	200	50	0	0
b	0	0	0	0	300	0	0	150
c	100	50	0	0	200	400	25	25
d	300	300	100	160	50	100	0	0
e	0	0	50	100	50	100	0	0

Apologies for not making it clear

Emin

[settu_periasamy · Accepted solution]

Hi,

May be CrossTable?

[Anonymous]

Hi there!

thanks a lot! I appreciate your help! exact;y what i needed to know.

Regards

Emin