Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Maybe something like
=COUNT(TOTAL<Material> DISTINCT Orden)
It worked fine.
Thanks for your support!
Can I assign a number of row that starts with every new Material?
Can I assign a number of row that starts with every new Material?
Rank(-Orden) should do it as long as you maintain the sort order the way that you have it.
Brian, I´ve tried but it returns allways 1.
What I´m trying to do is to apply a formula for the first record of each material and another for the rest.
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
Great Brian, thank you very much!