Hi Experts ,

I am using line graph to show weekly trend .

using one dimension eg region , week to show trend , using region as filter ( east , west, south , north) , sales , when I select all region from filter , graph

is not looking good , because some of region is not having sales on all weeks , so my user wants , if I select south ,east from filter ,then  lines graph

should sum up(Sales) of east & south  ,and should show only one line , if I select south ,east,north then again should show only one trend line only with

the summed values of south ,east,north like that .

If I select all region then there should be only 1 trend line summed of all sales values .

any idea on this experts ?