Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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))