Dynamic Selection of Field in listboxes

[#1]

Hai,

I am attaching a file , I have created two groups and list boxes with those two groups,

Group1

categoryname

companyname

Firstname// Employeename

group2

Sum(extendeprice)  //sum(sales)

sum(quantity)

now I want the chart to display the data year wise , when I select categoryname and sum of quantity,

categoryname and sum of sales.

similarly companyname and sum of quantity

.

...

.

so when I select any of those fields, the data should be displayed in Pie chart,

Please can anyone have the  idea to solve this problem

Regards,

Ramesh

[MayilVahanan]

Hi

PFA

[#3]

You don't need variables with a pick/match functions since the values of Group1 and Group2 contain the field names and expressions, respectively. Just use $(=Group1) as your dimension and $(=Group2) as your expression.