Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello got a pivot table with dimensions:
Workgroup, Resource, Month Year, and Project
I got 2 expressions:
Planned mandays and availability
I want the availability to show results only at the level of workgroup, month year, and resource
I tried using the aggr but it shows the total at resource for one project
HI. Just to understand what you're specifically asking for, are you saying that you only want the total for availability to be blank at the project level?
If so, then you should be able to accomplish that using the Dimensionality() function.
Based upon the image posted, I think the dimensionality of project is 3. Therefore, you could try something like:
If Dimensionality() > 2, '', [availability])
If you add DImensionality() as a measure (temporarily) then you can verify what the value is for each Dimension.
thank you for your reply
I did try this but the thing is that users may change the order of dimensions and this will break the logic of using dimensionality() check in the expression