Is it possible to count number of rows in straight table chart? How can I do that? I have a table chart with few dimensions, cycle groups and expressions. Since chart is too busy, an option was suggested to display number of rows present at any given time to restrict user from exporting to excel. If rows are higher then certain number user are warned before they export it to excel. How can I get number of rows in a chart?
looks like we are going in the right direction. Now, How do I get that rownum in the title of the chart. For example, you have 4 as maximum number of rows in your test application. How can that be placed in the title of the chart where you have 'Sales = 2969'. I want to replace title of the chart as 'Max number of Rows = 4' instead of 'Sales = 2969'. MAx number of rows changes every time chart updates with slice of the data.
Please find the attached sample file.
As well, This solution will respond to the selection made.
i.e., it shows the number of currently visible rows in the straight after making any selection.
Hope this helps.
Andrew: There is nothing in QV sample document that you have attached. Please reattach.
Sunil: I create the table in GUI and not in load statement of QV ETL. your suggestion will not work for me.
Iyyapan : your seems to be the most helpful solution at this point.