Forum Discussion

mussaenda's avatar
mussaenda
Community Champion
7 years ago

Group based on Condition

Hi Community,

 

I am doing a Logisitcs repot and I need your  help.

 

I am using matrix table and I want to group some values:

 

If the Code is CFR, I don't want to display Sea Destination Charges.

If the Code is DAP, I want to show Destination Charges but like the first column.

 

Output will be:

CFR

Ocean Freight 20'  |  Ocean Freight 20' | Ocean Freight 20'  | Ocean Freight 20' 

 

DAP

All inclusive 20' (FRT + DEST)  | All inclusive 20' O/T (FRT + DEST)  |  All inclusive 40' (FRT + DEST)  |  All inclusive 40' O/T  (FRT + DEST)

Need Help

2 Replies

  • parry2k's avatar
    parry2k
    Super User
    7 years ago

    mussaenda you cannot hide the column dynamically, only thing you can do is to return blank in your measure calculation if code is CFR