Display values on a scatter chart without aggregating and hard-coded filter

[#1]

Doubt 1 :In the attached qvw, I created a qvw. Here I want to display the dots at each record, that is one dot for one record. I have used the dimension as bmc_desc, so

the final dots are aggregated at the bmc level. I have used expressions as sum(incremental_sales) and sum(imcremental profit), but I want to show the

incremental sales and incremental_profit of each dot. But nothing is displayed when I use just "incremental_sales" as the expression.

Please suggest how to display dots at each record level and then all records belonging to a single bmc have one color.

data_context

sub_category_code

sub_category_desc

family_code

week_id

week_num

promo_sales

baseline_sales

incremental_sales

incremental_profit

discount

avg_nbr_of_baskets

baseline_nbr_of_baskets

basket_size_impact

incremental_traffic

net_basket_impact

quadrant

weekly_amt

bmc_desc

avg_basket_size

baseline_basket_size

brand

vendor_name

promo_code

promo_start_date

promo_end_date

supplement

press

tv

radio

smart_shopper

instore

																												0
-Super-All	G120201	RICE	11852	201146	46	18788.79	16913.97	-468.747	-2595.42	0.243324	301	223.8628	-155.87	77.13719	12562.26	4	8079.1	KIDS CEREALS	615.2133	771.083637	KELLOGG'S	Kellogg Company SA (Pty) Ltd	NULL	00:00.0	00:00.0	1	0	0
I-Super-All	G120201	RICE	11852	201147	47	15233.55	15495.99	-2162.55	-3633.04	0.243466	246.6667	210.244	-84.941	36.42267	5856.349	4	6550.45	KIDS CEREALS	651.0967	736.037626	KELLOGG'S	Kellogg Company SA (Pty) Ltd	NULL	00:00.0	00:00.0	1	0	0

Doubt 2 : Is there a way to hard-code the filter. For example in the qvw attached, you can see a filter DAta context which has three values. Is there a way to remove that list box and by default set the filter condition to All

[#2]

Mayil,

can you see the qvw I have sent you? I hve used this..but I m not able to set bmc_desc as the legend.

[MayilVahanan]

HI,

Use bmc_desc as third dimension ..

May be it helps

[#4]

At least I can see bmc_desc as legend, but not sure if the results are correct or not...will cross check with the database and confirm.

Also, how does it make a difference 3rd dimension or second dimension, on what basis is the legend selected, Can you please clarify that?

Thanks!