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]

pls any one reply me

[manoranjan_d]

[manoranjan_d]

i m totally stuck with this pls help me

[#5]

sample application pls

[miguelbraga]

Hey there,

As khushboo Pewani asked, I ask again. Can please share your qvw? I'll try to understand your issue and make your solution come true

Thanks,

MB

[Anonymous]

will it fit?

PFA..

[Anonymous]

If you want to stack chart like this: to get the style of stack chart minimum teo expression required

See the attachment....u can change it as per ur requirement

[manoranjan_d]

Hi,

I ave attached the values not sorted and colors are not proper order

[manoranjan_d]

Hi all,

i have attached the file for your reference, i need the colors to be in proper order and then the values has to be sorted from low to high