Matrix Table same column Row/Column

[Anonymous]

Hi Team,

I have below data and I need expected chart with same column (Row/Column)

Data :

Expected Chart:

Thanks,

Y_DK

[amitchandak · Accepted solution]

@Anonymous , Create two columns like this in the table and use in matrix row and column

Import country = if([Type] ="Import", [country], blank())

export country = if([Type] ="export", [country], blank())