Forum Discussion

bansikpopat's avatar
bansikpopat
Frequent Visitor
3 years ago
Solved

Filtering 2 columns with different filter values in a table

I have created a table as below -  The last two columns - Total stock and QN are calculated columns. They are summation of different columns.  I have a requirement to filter these last two co...
  • amitchandak's avatar
    amitchandak
    3 years ago

    bansikpopat ,

    New columns

    Total Qty = Switch( True() ,

    [ Storage location] in {"0010","0020","MDD","MDR"} , [Confirmed Qty],

    blank()

    )

     

     

    QN = Switch( True() ,

    [ Storage location] in {"ATQN",
    "GGQN",
    "RQTF",
    "AQTF",
    "ASEG"}
    , [Confirmed Qty],

    blank()

    )

bansikpopat's avatar
bansikpopat
Frequent Visitor
3 years ago

Thanks it worked. But I had to make a small change as I wanted to see the value of QN columns after filteration. 

QN Column =
SWITCH(
True(),
[Storage Location] in {"0010","0020","MDD","MDR"},
[QN], blank()
)