What is NoOfColumn() and Column No() ?

[nikhilgarg]

Hello,

Can anyone help me the use of Column No() and No of columns() with example ?

thanks

[nikhilgarg]

Hey,

In my pivot table, i ahve 4 dimensions and when all 4 dimensions are expanded, i have dimensionality() as 4, 2, 1.

Now, i want sum of 4+2+1 as 7 and i tried:

sum(aggr(Distinct Dimensionality(), SalesRegion, Desk)), but still sum is not 7.

How cld i acheive this?

[MK_QSL]

Nikhil,

I want to see if you have expanded all 4 dimensions, how you are getting 4, 2 and 1 as dimensionality?