Sorting

[jadams123]

This question may be difficult to ask but i'll try.

My object is in a straight table.

So I have one dimension with is called (Category). This has Beverages, Breads, Milk e.t.c

But I have multiple calculated expressions (Sales, Margin, Margin % e.t.c)

One of the columns is called "Contributor" and this column is in %.

I have sorted it my lowest to highest %.

But I only need to show first 10 categories. The rest I don't want to show.

How can I do this..

J

[antoniotiman]

Hi Joe,

'first 10 categories' about what ? (sale,margin,margin %, contributor ... ?)

[vishsaggi]

IN the Dimensions Limits tab just show 10 largest like below?

Or use a calculated dimension like

= IF(Aggr(Rank(Sum(yourfieldname), 0), Category) < 11, Category)

[jadams123]

I need the first 10 in contributor.

I tried "Show Only" and the object gives me an error message.

I just need to show top 10 contributor column (this is a calculation).

[vishsaggi]

Can you share a sample to look into and what is that error you are getting and where exactly you are getting an error?

[jadams123]

This is my object:

There are about 140 categories (First column).

In the "low margin contributor" (Last column) column I have sorted by lowest to highest. And I just want to show the first 10 numbers.

When I do this:

it shows me this error:

There must be a way to just show the first 10 rows.

Thanks,

J

[Anonymous]

The "Show Only" option should work if the expression "Contributor" is promoted to the first expression.

[jadams123]

I promoted it to the first expression. It still shows error msg still.

By the way Contributor is a calculated expression. Example I am let say doing this [Invoice Margin Week %] * (set analysis)/(set analysis)

So I am doing some calculations in this column.

[vishsaggi]

Did you try the rank function? I cant assume the fields and write an expression as it might be right or wrong, a sample qvw file will help to quickly work on it. If possible please upload your sample to have a quick check.

[jadams123]

I am a front end user of QV. I don't have access to qvw files