count dimension in straight table

[narender123]

Hi Team,

I have a table in which I have instance_id, Reg_no, and amount columns.

I want to show the count of Reg_no below Reg_no dimension. Is it possible?

Like:

instance_id        Reg_no     Sum(amount)

1                                a121           50

2                                 b131        150

3                                 t511        100

 Total                           3            300       

Thanks,

Narender

[paulselousyoriz]

Hi Narender,

You can create "Reg_no" as a measure in the table, and then in the "Totals function" drop-down in the measure, select "Count".

Regards,

Paul