Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Can anyone help me the use of Column No() and No of columns() with example ?
thanks
What are the numbers you are expecting to see?
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
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
haha, no prob buddy.
thanks
You could try with Dimensionality() function.
I tried but no success
Hi
As per my knowledge, You can't able to hide the column based on dimensionality of pivot table.
Ohk,
Thanks
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?
Can you provide sample of your Pivot Table?