How to Count Number of Column in Pivot table..?

[sgg_gaikwad]

I want to create Variable for that & it should come without MIcro

[SergeyMak]

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

[sgg_gaikwad]

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

[SergeyMak]

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.