Make specific table cells Null

khaled_altaher — Sun, 22 May 2022 08:42:38 GMT

Hello All!

I'm looking for a way to make specific cells be Null in a pivot table,

for males only to be null, even if it has data.

I tried
if(GENDER = 'Male' AND TREATMENT_GROUP_NAME= 'EC', Null(),
Sum({<TREATMENT_ELIGIBILITY = {"Eligible"}, TREATMENT_GROUP_NAME = {"EC"}>} FIELD_VALUE))

Is there any possible way to make it work.

Re: Make specific table cells Null

Andrei_Cusnir — Mon, 23 May 2022 09:03:28 GMT

Hello,

I have an example with demo data that you can take a look. If it suits your needs, you can modify it by changing the expression's details:

1. Demo dataset:

2. I have created a Pivot table with:

Dimension 1: Product
Dimension 2: Gender
Measure: Sum(Value)

3. Now I have changed the measure expression to:

If(Gender = 'Female', Null(), Sum(Value))

As you can see, all the Value values for "Female" are Null(), while for the rest is the calculated expression.

I hope that this information was helpful. In case I have misunderstood the use case scenario, please elaborate in details by providing additional information. However, if it has helped you resolve the issue, addressed your concerns or at least pointed you in the right direction, please mark it as Accepted Solution to give further visibility to other community members.

topic Make specific table cells Null in Management & Governance

Make specific table cells Null

Re: Make specific table cells Null