how to calculate top 10 in straight table and wit top 10 subtotal with 3 dimension and 3 expression

[amita1621]

Hoping someone can help. I have a Straight table with the displayed values limited to the Top 10. What I'd like to calculate is the sub-total for that Top 10. I also need to subtotal the entire data.

Does anyone have any ideas?

Much appreciated!

[Arthur_Fong]

Is this the expected result?

In chart properties > presentation > check "Max Number".

Expression for top 10 :

avg({<[Student Id] ={"=Rank(avg(marks))<=11 "}>} marks)

Refer attached qvw for reference.

Thanks and regards,

Arthur Fong

[amita1621]

Hi,

Thanks for the response but I am expecting something different.

I have 3 dimension and 3 expressions. Now on 1st dimension, I need top 10 records and display the sum of top 10 and Others and also the total amount. And also need to sort on one of the expression/

[Arthur_Fong]

Maybe you can provide a sample qvw and your expected output?

[amita1621]

I need in this format.I have given top 5 data.

[Brett_Bleess]

Amita, in this situation, it is most likely going to require that you post a sample app with your data model and chart with expressions etc.  It does not have to be the full set of data, but enough that folks will be able to see how the data model is setup and what you are doing with the expressions.  Not sure you are going to get what you need otherwise on this one, as it is a bit difficult to follow without being able to see the other detail.  Just wanted to try to move things forward for you.  If you have some confidential fields, you can use the Settings\Document Properties\Scrambling tab to scramble those, but if any of those fields are being used in your expressions, that may prove problematic as well.

Regards,
Brett