One chart always shows one name (dimensions)

[Sxbbb]

I want the first chart to show the first name = KAIMA_4W and the second chart to show the second name = LM1000 #1 to the sixth chart to show the sixth name = NIDEC SW#2. One chart always shows one name before selecting. name in another type always shows type= 4-wire Fixture with six name first.

[Vegar]

You can control which dimensions to include in your calculation by using set analysis.

I am assuming your current calculation is Sum(Value). In order to make sum(Value) to only calculate for the Name: KAIMA_4W you can add a set modifier like this:

Sum({<Name={'KAIMA_4W'}>}Value)

[Sxbbb]

i tried this but if i press name=A3030#1 chart it doesn't show data I want when selecting a different name the value will be displayed.

[marcus_sommer]

You could make the assignment of names dynamically by querying the possible values of this field. This may look like:

sum({< Name = {'$(=subfield(concat(distinct Name, '|',), '|', 1))'}>} Value)

whereby the bold number is the index-number which item will be returned from the read fieldvalue-list.

Beside of this I could imagine that a grid-chart is more suitable. You could enable it within the object-properties in tab dimensions on the bottom left.

- Marcus