How to summarize a filter on a chart?

[semsel]

I have a line chart and i'm applying filter to the series (lines).  The lines represent the Itemtypes and the filter is to show data only for Sand,Resin, Glass- A, Glass -B etc. But I want to show Glass- A and Glass - B as a single line. how to achieve this?

[HalfBloodPrince]

try this create new query calculation as follows for item types

if( [item types] in('Glass A','Glass  B' )) then

('Glass A'+' and '+'Glass B')
else
([item types] )

It wil automatically show u the data summarized for glass1 and glass2.

Now to filter this data u also have to put same calculation in ur filter query data item , so that it wil show the option 'Glass A and Glass B'

[semsel]

Thanks for your answer !