how to change Column format from duplicated table

[Amp_]

Hey Everyone!

i would like to ask about matrix table. i want col. to show sum of Vol. fail case in itm_sts_mod but after i made, condition show duplicate table of fail case

In the fail case, You can see itm_sts Col. have 2 status which is Cancelled and NPASS so that's why data show dulipated 

= IF(UPPER(v40_report_inq_sts[prc_sts])="NPASS","F3"  <---- this dex is for fail condition

Would you be so kind to solve this problem? Thank you in advance 🙂

[Anonymous]

Hi buddy,

I don’t quite get what you’re trying to do here.

Are you trying to add an extra column in a table to count how many cases has Failed or NPASS as in status? If yes, what is the table structure that you are using and what are the combination you have used to create your matrix “Rows, Columns and Values”? Usually screenshots would do great help with these kinds of scenarios.

If the above is not useful or you think it is irrelevant perhaps you consider rephrasing your query?

Kinds regards

Hicham

[Amp_]

Hey Hicham,

I'm trying to add colume to count how many cases has Failed in status

actually i have 3 conditions of fail case 

inq_itm_sts_mod = IF(UPPER(report[Conditions]) in {"F1","F2","F3"} ,"Fail"

-----  F1 & F2 :  inq_itm_sts are Cancelled 

----- But only F3 : inq_itm_sts have 2 status which is  Cancelled and NPASS (so matrix table show duplicated)

e.g.

Conditions = 

IF(UPPER(report[inq_itm_sts])="Cancelled" && UPPER(report[Cancel_sts])="1" && UPPER(report[prc_sts]) = "PASS" , "F1"

,IF(UPPER(report[inq_itm_sts])="Cancelled" && UPPER(report[Cancel_sts])="0" && UPPER(report[prc_sts]) = "PASS" , "F2"

,IF(UPPER(report[prc_sts])="NPASS","F3" 

and i created matrix of

1. Count of ID

2. Sum Quantity 

3. measure of Avg. 

 

Regards

Amp

[Anonymous]

Hi Again,

And please bare with me 🙂

Can you please post a screenshot of a table showing the view that you are trying to calculate?

e.g.:

I hope this makes sense 🙂

Kind regards

Hicham