topic Re: How to make an expression display nothing at some level in App Development

How to make an expression display nothing at some level

ali_hijazi — Mon, 27 May 2019 10:28:12 GMT

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

Re: How to make an expression display nothing at some level

lblumenfeld — Tue, 28 May 2019 02:04:38 GMT

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.

Re: How to make an expression display nothing at some level

ali_hijazi — Tue, 28 May 2019 06:59:06 GMT

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