top values for region

[#1]

Hi,

Below is my table

Year, Subject , Marks

    2011, ABC, 30

    2011, ABC, 23

    2011, ABC, 23

    2011, ABC, 43

    2011, GEF, 12

    2011, GEF, 43

    2011, GEFD, 12

    2011, GEF, 32

    2012, ABC, 43

    2012, ABC, 54

    2012, GEF, 12

    2012, GEF, 54

    2012, GEFD, 54

i need to display jst year ,top subject based on sum and sum of marks

2011    ABC 76

2012    ABC 97

in a straight table

[swuehl · Accepted solution]

Try creating a straight table with dimensions Year and Subject, use

=sum(Marks)

as expression.

Assuming you are using QV11, go to dimension limits in chart properties and enable option 'Restrict which values are displayed..' - 'show only largest 1 value' for the second dimension.

[#3]

I am not getting what i need with it

iam getting

2011 others 218

2012 others 217

[swuehl]

Try unchecking the 'Show Others' option on the dimension limits tab.