Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Joe,
'first 10 categories' about what ? (sale,margin,margin %, contributor ... ?)
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)
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).
Can you share a sample to look into and what is that error you are getting and where exactly you are getting an error?
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
The "Show Only" option should work if the expression "Contributor" is promoted to the first expression.
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.
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.
I am a front end user of QV. I don't have access to qvw files