Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
this needs to be added as an expression, i think you trying to add it as a calculated dimension
Can you post a screenshot of the expression on the expression tab of the chart properties?
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])
this needs to be added as an expression, i think you trying to add it as a calculated dimension