What is NoOfColumn() and Column No() ?

[nikhilgarg]

Hello,

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

thanks

[sunny_talwar]

What are the numbers you are expecting to see?

[nikhilgarg]

I ahve pivot table with 4 dimensions and 8 expresions.

If i have all 4 dimensions expanded then i want expr1 to expr7 visible and dont want expr8 visible.

If i have only first 2 dimensions expanded and rest 2 dimensions colapsed then i want expr1 to expr6 and expr8 visible and don't want expr7 visible.

How can i acheive this?

Thanks

[sunny_talwar]

Hahahaha, I saw your earlier post, but I don't think I know if a way to make that happen. May be somebody else might now.

I am sorry Nikhil, I wish I could have been more helpful.

Best,

Sunny

[nikhilgarg]

haha, no prob buddy.

thanks

[#6]

You could try with Dimensionality() function.

[nikhilgarg]

I tried but no success

[MayilVahanan]

Hi

As per my knowledge, You can't able to hide the column based on dimensionality of pivot table.

[nikhilgarg]

Ohk,

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]

Can you provide sample of your Pivot Table?