Counting number of rows

[#1]

Hi, i have a simple chart - straight table, and in a text box above i want to show number of rows in this table. Is there any way to do this ?

[alexandros17]

it is possible in the caption of your table, simply doing Count(myfield) where myfield is a field in your table

[Gysbert_Wassenaar]

Try =sum(aggr(1,Dim1,Dim2,...,DimN)) where Dim1,Dim2,...,DimN are the dimensions of your straight table. This doesn't always work correctly. If you suppress values in the straight table, for example with set analysis, then the count can be off.

[sudeepkm]

how many dimensions do you have. Mostly in the st table based on the dimension you will have the number of records. you can create a text object to count the Distinct Dimension field values.