show number of rows in report

[aheavy95]

Hi all

I need to add to my report the number of rows that exist in it at any given time. 

I was asked to place this counter on top of the report as a kpi (near the date time)

any Ideas? 

thanks

[rubenmarin]

Hi, hard to say witout knowing the dimensions and expressions used and the data model behind, but as an idea, you can try with Count(distinct Item_Code) and applying a set analysis that mimics the one(s) that the table does.

[aheavy95]

I added a rowno() column

now all I need is to get the max (last) number which is 950 in this case and place it on top somehow

any ideas?

[sidhiq91]

@aheavy95  Just add rowno() function in the measure. And then totals function select Max, that would show the Max value at the top of the column. Please see the screen shot below:

[MayilVahanan]

HI

Try like below in KPI

=Sum(Aggr(1, urdim1, urdim2, urdim3))

or, if you have primarykey in the table, then 

=Sum(Aggr(1, urprimarykey))

[aheavy95]

do you mean as an additional column in the table? how do I view it as a kpi?

thanks