Issue -Line chart with 2 dimensions

[Pulkit_Thukral]

Using a line chart with 2 dimensions ,Primary dimension being the 'Date' figure and secondary dimension is a general field (Ex- Engineers).

Requirement is to restrict Engineers to 'TOP 10' among the entire data which in the chart is showing improper values.

Being the secondary dimension Different Top 10 values are coming for each Date value(Primary Dimension).

How to restrict this issue to only secondary dimension with top10 values in entire data and not on each date values. ??

[swuehl · Accepted solution]

Try using a calculated second dimension like

=aggr( if( Rank(Sum(Value),4,0)<=10, Engineer), Engineer)

See also attached a sample QVW.

edit: Corrected a typo

[Pulkit_Thukral]

Thanx for your help .

Its working