Stack bar

[manoranjan_d]

Hi all,

Count	Type	Country	Data source
200	male	UK	Data3
1800	male	UK	data1
28500	Female	US	data5
28500	Female	US	data5
62500	Female	Pak	data5
62500	Female	Pak	data5
97600	Female	China	data5
97600	Female	China	data5
139500	male	india	data1
181800	Female	india	data5
181900	Female	UK	data5
193500	Female	india	data5
200000	male	india	data2
200000	male	Pak	Data3
320500	Female	UK	data5
500400	male	india	Data3
700000	male	UK	data2
800000	male	Pak	data2

above is my data i want the data be viewed in stack bar

as per the country wise, with data source and  then type, and then in that type the i need th overall count

i used dimension as country, data source and type

i used in expresion as =Dual( data source&'-'& Num(Sum(Count),'#,##0','.',','),Sum(Count))

the value has to plot inside segments and then value has to sort and the  colors has to be arranged.

pls help me on this

[manoranjan_d]

I've attached the file pls refer

[manoranjan_d]

I've attached the file for your refernce

[Anonymous]

is this you want?

[manoranjan_d]

no, when u see the value of second stack bar values are not in low to high ,

when u see the fourth stack bar the color is getting differ becoz, we shd get only sky blue and orange in proper order.we are getting orange and green in the fourth stack bar.

[manoranjan_d]

all the stack bar should use three color blue, orange, and green and these color has to assigned according to the sort value, example

if the stack bar has two values then it should show blue and orange

if the stack bar show one value then it should show only blue

if the stack bar display three value then it shd dsiplay the three color blue, orange and green

[manoranjan_d]

these inside value has to be sorted from low to high

[#8]

See attached for sort

[Anonymous]

It works for 2 dimension but when we add DataSource as well it doesnt work

[manoranjan_d]

where is the data source kushshboo

[manoranjan_d]

this is the thing i m totally stuck no sol for this , please help me with some other solution i can propose it