Count of rows on top of Table Chart

[Shahzad_Ahsan]

Hello Everyone

Please view the attachment first.

Ques 1: Total is not visible on top. Why??

Ques 2: Is it possible to calculate count of rows(No of records) on the top of the chart ???

I dont want to use pivot table.

So please suggest in Table chart only..

Thank you.

[OmarBenSalem]

Don't why it's not appearing; try to refresh..

but you can change the 'total' name to : ='count of field is : '&count(total yourField)

result:

[arvind_patil]

Hi Shahzad,

Please enable total button and check.

Thanks,

Arvind Patil

[shraddha_g · Accepted solution]

Total is only shown for Measures. and in your Image there is no expression used.

Add Measure. Say Flag

In that Measure section, there will be an option of Show Total as. There you can choose Count as aggregation function

[Shahzad_Ahsan]

Thanks Shraddha

Now I got to know that total is always shown for measures.

Previously i was using as dimension.

[Shahzad_Ahsan]

Thanks Omar