Hello Hua, what you're looking for is a Sumo card instead of a regular card. Here's the result you're looking for : When you click the add card button on a page, a grid of card options are shown. Choose 'Sumo' as shown here : A Sumo card can show data as columns or as a crosstab. You need the crosstab view. Here is a…
Hello Hua, if you still have a need for this please can you send me your source data from your screen shot? I can take a stab at this for you, I'm pretty comfortable with MagicETL. Cheers, JJ.