CASE ISSUE

[#1]

Hi All,

I have a data as shown below

PRODUCT	PAYMENT_TYPE	STATUS	VALUES
TTC	CC	TIER1	65
ASD	CASH	TIER2	34
DFD	CC	TIER1	54
VGF	DC	TIER3	32
BGH	CASH	TIER5	34
NGT	ONLINE	TIER6	56
ERT	CC	TIER7	45
FDV	CC	TIER4	56
FDE	DC	na	67
JKL	CASH	na	45
OPI	ONLINE	TIER2	45

1) I have created a pivote table expression (=SUM(VALUES)

2) I have all the above information in the pivote table.

Issue: For few products (ASD & DFD I want the "STATUS" as null and for rest products it shold reflect from the data

Thanks in advance...

Regards,

KK

[alexandros17]

STATUS is a dimension so write in the dimension (Use Add Calculated Dimension):

If(STATUS='ASD' or STATUS='DFD', Null(), STATUS)

If you do not want to see null values check the exclude null values box

Let ,me know

[lironbaram]

if this a an expression you could use

if(match(PRODUCT,'ASD','DFD')=0,STATUS)

if it a calculated dimension you could use

aggr(if(match(PRODUCT,'ASD','DFD')=0,STATUS),PRODUCT,PAYMENT_TYPE)

[bbi_mba_76]

Hi,

maybe adding a calculated dimension

=if(match(PRODUCT,'ASD','DFD')<=0, STATUS)