RowNo(TOTAL) does not work

[ananyaghosh]

Hi,

I want to show the row no of a table and I ma using RowNo(TOTAL) in the expression side. But it shows nothing as below

Please let me know what to correct?

[sunny_talwar]

Can you post a screenshot of the expression on the expression tab of the chart properties?

[tresB]

If you are using it as a calculated dimension, try like: = Aggr(RowNo(), [%Office Key]) and if you are looking for total number of rows, try = Aggr(NoOfRows(), [%Office Key])

[vinieme12 · Accepted solution]

this needs to be added as an expression, i think you trying to add it as a calculated dimension