Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to create Variable for that & it should come without MIcro
Hi Swapnil,
Could you clarify why you need this number?
Because in pivot table you usually have dimension and the simple way is just Count(DISTINCT Your_Dimension).
If you have two Dimensions as column just multiply them Count(DISTINCT Your_First_Dimension)*Count(DISTINCT Your_Second_Dimension)
etc.
Regards,
Sergey
Hi Sergey,
Thanks for your Response but the thing is i don't want to show that count in Pivot table..
i want it to show in Text box ( After any selection on dashboard it should count number of column in Pivot table)
Regards,
Swapnil
Swapnil Gaikwad wrote:
Hi Sergey,
Thanks for your Response but the thing is i don't want to show that count in Pivot table..
i want it to show in Text box ( After any selection on dashboard it should count number of column in Pivot table)
Regards,
Swapnil
That's why I asked you "Why you need this number" and my solution is good good for your purpose.
You, probably, know your dimensions in the pivot table. So just use them to count in text object.
If you share the app, I can calculate it for you.