How can i get value of column when that column use a count expression

[#1]

I have one column what value use a COUNT, and i need get the major value, but i cant use MAX because the count, and i cant use order that column to use TOP after, someboby can help me???

tks a lot!!!

[#2]

try with NoOfRows( [ total ] )

[#3]

I dont need the number of Rows, i need the most value of the column

tks

[#4]

Is your count in the script or an expression?

[#5]

I don't understand, don't you need the max value of a count? What's the difference with using NowOfRows, specifying a dimension or not?

[#6]

I am not sure NoOfRows would do it. It sounds like, and correct me if I am wrong, that he is looking for the Max of the returned counts. NoOfRows would indicate how many rows are in his data which could be 100 when the Max Count could be 10.

If you are doing the count in an Expression I might suggest doing it in the load script so that something like Max would work.

Just a thought.

[biester]

Why don't you post an eloquent example so that community can try to work out on this???

Rgds,
Joachim

[#8]

I´m doing in the expression, how can i doing in the load script, i dont known this yet??

[#9]

i have 4 dimensions, and 2 expressions, first expressions(column) i used =COUNT(Codigo_Proposta), and the second i need get the major value of first column, but i cant order and use top because that process repeat size by size some times because the dimensions day and month....

[#10]

I agree with biester. Can you attach a sample file that shows us what you have so far? With a sample we can play around and find you the solution a lot better.

As for doing a count in the Load Script, that is fairly easy. The same syntax you use in your expression is used in the Load Script. For Instance:

Load SomeKeyField,

Count(Distinct SomeOtherField) As NumInstances;

SQL SELECT SomeKeyField,

SomeOtherField

FROM SomeTable;

This is a very simple example but hopefully it helps you understand the Count function in the Load Script. Once you have the data loaded you can use Max(NumInstances) in one of your Dimensions to get your max value.