topic Re: CASE ISSUE in Water Cooler

CASE ISSUE

Thu, 05 Jun 2014 09:02:19 GMT

Hi All,

I have a data as shown below

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,

alexandros17 — Thu, 05 Jun 2014 09:05:11 GMT

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 — Thu, 05 Jun 2014 09:06:10 GMT

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 — Thu, 05 Jun 2014 09:07:20 GMT

Hi,

maybe adding a calculated dimension

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