Matrix Table Transpose Rows represent column and Column represent Rows with multiple data type $,%

[NehaSha]

Hello everyone!

Need help to show Matrix Table Transpose

	NetRentTY	GrossPot	Auction Percentage	TotalArea
Actual	$500,000	$510,550	39%	1000
LY	$500,000	$510,550	40%	900

to 

	Actual	LY
NetRent	$500,000	$500,000
GrossPot	$510,550	$510,550
Auction Percentage	39%	40%
TotalArea	1000	900

with $sign,%sign,Comma between numbers and Whole Numeric Number or Decimal Number 

Thanks in advance!

Thanks,

Neha

[MFelix · Accepted solution]

Hi @NehaSha ,

Not sure how you have your data setup but if your matrix table looks like the first one you show, select the options on the matrix visual and go to values, then turn on the option Show on rows, the values that you have as values will appear in rows instead of columns.

Be aware that your Actual / PY column needs to be in columns and not on rows.

Regards,

MFelix

[MFelix · Accepted solution]

Hi @NehaSha ,

You can add a column to each table refering to  Category (Acctual / PY), then rename the columns on both table to the same name and make an append of the data into a single table, then you can use  the solution I gave.

Regards,

MFelix