3 stack bar with value low to high

[manoranjan_d]

hi all, below is the data,

now i need the data in 3 stack bar in single chart.

First  stack bar should tell the sum of IT and CSE

second stack bar should tell the Sum of IT present and Absent

third stack bar should tell the the sum of cse present and absent

note: all these values in the stack bar stock display inside the segment and  the values should sort low to high.

Dept	Count	PorA
IT	500	A
CSE	700	A
IT	800	A
CSE	900	A
IT	1000	A
CSE	1100	A
IT	1200	A
CSE	1300	A
IT	1400	P
CSE	1500	A
IT	1600	P
CSE	1700	P
IT	1800	P
CSE	1900	P
IT	2000	P
CSE	2100	P
IT	2200	P
CSE	2300	P

[manoranjan_d]

in the stack bar i need the IT and CSE has to segregated

[manoranjan_d]

no reply

[MK_QSL]

Like this?

[MK_QSL]

Or simple create a Bar Chart

Dimension : No Dimension

Expressions

1) SUM(Count)

2) SUM({<Dept = {'IT'}, PorA = {'P','A'}>}Count)

3) SUM({<Dept = {'CSE'}, PorA = {'P','A'}>}Count)

Go to Style Tab and Select Stacked From SubType

[manoranjan_d]

no wrong , i need separate stack bar

[MK_QSL · Accepted solution]

Create a Bar Chart

Use two Calculated Dimensions

1) =ValueList('All','IT','CSE')

2) =ValueList('A','P')

Use below Expression

IF(ValueList('All','IT','CSE') = 'All' and ValueList('A','P') = 'A', SUM({<PorA = {'A'}>}Count),

IF(ValueList('All','IT','CSE') = 'All' and ValueList('A','P') = 'P', SUM({<PorA = {'P'}>}Count),

IF(ValueList('All','IT','CSE') = 'IT' and ValueList('A','P') = 'A', SUM({<PorA = {'A'}, Dept = {'IT'}>}Count),

IF(ValueList('All','IT','CSE') = 'IT' and ValueList('A','P') = 'P', SUM({<PorA = {'P'}, Dept = {'IT'}>}Count),

IF(ValueList('All','IT','CSE') = 'CSE' and ValueList('A','P') = 'A', SUM({<PorA = {'A'}, Dept = {'CSE'}>}Count),

IF(ValueList('All','IT','CSE') = 'CSE' and ValueList('A','P') = 'P', SUM({<PorA = {'P'}, Dept = {'CSE'}>}Count)))))))

[manoranjan_d]

is this only one expression

[MK_QSL]

Yes

[manoranjan_d]

thanks manish, but can u expalin the expression