Reformatting Rows Separately

[Anonymous]

Hi All,

I've created a report with various Balance Sheet line imems. One of the visualizations is the highlights for Assets. I've created a matrix table with 3 columns (I converted them from rows), inclusive of "Previous Period", "Current Period", and "% Change". While I would like to retain the periods as $ formats, I would ideally make the % chage in % form. Given that the data's set up as rows (I'm well aware of the limitations, but think there are positives to this structure), I am unable to solely change the one set of variables. 

I'm wondering if someone can be of help, utilizing the below images.

Thanks!

[v-xicai]

Hi @Anonymous ,

You might enter into Query Editor, click on the column [Time Period], go to Transform-> Pivot Column, then this [Time Period] column can be converted into three column [Current Period], [Previous Period] and [% Change]. You can then click on [% Change] to format it in "%" .

Best Regards,

Amy

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thanks for the tip, Amy! Unfortunately, given the importance of the other columns as individual variables, the transformation option is not viable as it removes the other variables' individuality and headers. I initially attempted to pivot the data, to no avail due to the null values.

I then attempted to transpose the column, which had the afformention outcome of not allowing individuality on the sought variables/variable heads.

Are there alternstive solutions?

@v-xicai