Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi
PFA
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.