Row Count

[jagjivvt]

Hi,

I am using this formula RowNo(TOTAL) and this places a number which is correct, but within the data set I need the count to also check a dimension and if this is the same for a few rows then the number should remain the same.

thanks

vijay

[MK_QSL]

Kindly provide sample data or sample app and then explain what you want to achieve !

[sunny_talwar]

May be use Rank(DimensionName)... numbering might be different, but if should rank the same dimension with the same number I think

[jagjivvt]

Hi tried that it just puts a 1 on each row.

[sunny_talwar]

How about this

Rank(TOTAL DimensionName)

[jagjivvt]

Hi Sunny this works, thanks

[jagjivvt]

hi Sunny,

is it then possible to change the result to a single number so that all the ones that are same starts with 1 and then adds 1 to the next set and so on.

thanks

vijay

[sunny_talwar]

Not sure I understand the output you are looking to get... can you show this via an example?

[jagjivvt]

Hi Sunny

please see below, in column C I need the 3 to be replaced with the Rank expression starting with 1 and then any additional to add 1 to it.

thanks