Need selected field value in combo chart

[#1]

Hello All,

I am having some issue, using combo chart.My requirement is,i am having 4 list box in front-end it is parent -child hierarchy.

i am using combo chart and pivot table,i want to display only the value for selected field.

But i am using this expression,

=sum({<year = {'$(V_YEARMAX)'},month = {'$(V_MONTHMAX)'}>} ParameterValue)

it is displaying  total value.

ex:- when i am selecting second dimension,it is displaying total value for second, third and fourth dimensions.my requirement is to display only selected field value.

any-one know the solution for this issue.

regards,

baru

[nilesh_gangurde]

Hi Baru,

Use the Cyclic dimension which will show values for single dimension which you will select.

Create the cyclic group for the fields which you want to add as a dimension.

Regards,

Nilesh Gangurde

[#3]

Hi,

thanks for your reply,

I am not taking all dimensions,i am using only one dimension.

which is showing in combo chart.

regards,

baru

[#4]

For the year and month in the variable and for the current selections you need right.

Try this code:

=sum({$<year = {'$(V_YEARMAX)'},month = {'$(V_MONTHMAX)'}>} ParameterValue)