I have a pivot table and it has 15 conditionally enabled dimensions. Those dimensions can be enabled through a user selections so he can decide which dimensions he wants to see in the pivot table
Now I have a problem. I want to display the count of rows in the pivot table title. Can someone please tell me how do I get the pivot table row count in the chart title. If the dimensions were fixed, I could have used count(distinct dimensions1&dimension2&dimension3) but here I dont know how many dimensions the user selects