Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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:
Hi Shahzad,
Please enable total button and check.
Thanks,
Arvind Patil
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
Thanks Shraddha
Now I got to know that total is always shown for measures.
Previously i was using as dimension.
Thanks Omar