count rows displayed

[#1]

I´m trying to count the rows displayed for each value of a column.

I´ve used both rowno(total) and rowno() however none of them gave me the amount of rows displayed for each "Material" column

I need to use the displayed value, because the cardinallity of the data doesn´t allow me to use count()

How can I solve it? 

Thanks in advance!

[swuehl]

Maybe something like

=COUNT(TOTAL<Material> DISTINCT Orden)

[#3]

It worked fine.

Thanks for your support!

[#4]

Can I assign a number of row that starts with every new Material?

[#5]

Can I assign a number of row that starts with every new Material?

[#6]

Rank(-Orden)  should do it as long as you maintain the sort order the way that you have it.

[#7]

Brian, I´ve tried but it returns allways 1.

[#8]

What I´m trying to do is to apply a formula for the first record of each material and another for the rest.

[#9]

If(Orden=Min(Total<Material> Orden),'Formula One','Formula Two')

Best Practice would be to make sure you use an aggregation function like Sum(...), or Only(...) around all that.

- Brian

[#10]

Great Brian, thank you very much!