one column with Metric value but multiple formats and percentage value gets summarized

[Anonymous]

I have an ask to build a dataset that contains a single column with all metrics and there are dimension value that  identifies the metric .

Below is the sample of metric and its value it is suppose to display without aggregation. But my report aggregates all % values and displays as summarized value. Is there a way to not summarize the values in Matrix, and also display multiple formats of data as per below i need to display $ and %  in the same column.  TIA!!

PS: The Metric Value column is created in a View from the database side, and there a UNION of all metrics is done.

Expected:

Site	Metric Name	Mon_yr	Metric Value
ABC	On Time Delivery (%)	Jul-2020	93%
ABC	On Time Delivery (%)	Aug-2020	100%
DEF	On Time Delivery (%)	Jul-2020	92%
GHI	Past Due Orders Amount	Jul-2020	$3,500
ABC	Past Due Orders Amount	Aug-2020	$3,700

Achieved:

[amitchandak]

@Anonymous , not very clear. If you measure you want to show on the row- You can use show in row property of matrix https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/

You can not show unaggregated values in values of matrix