count of rows in pivot table chart title

[#1]

Hi,

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

I will appreciate your help

Shah

[pokassov]

Hi!

You can calculate which dimensions were selected by user.

For example, add variable vTest:

=Concat( Name_Your_Field_For_User_Select,'&')

And then

=count(distinct $(vTest))