need help

[anithaMallam]

Hi All

            iam creating a report with the data in the matrix visual as shown in the below screenshot.

now i want to change the gross sales values to percentage to only the Difference rows in the matrix. the differences are calculated in the backend synapse data base.it is possible to change to percentage for these rows and also can i able to create new columns to show these differences as percentage in columns.Could someone please help me on this.

Regards

Anitha

[Anonymous · Accepted solution]

Hi @anithaMallam ,

As you said,  the differences are calculated in the backend synapse data base , so could the Difference (DW-Source)...be the original data in tables? Like below:

Actually please provide more details about the table and the expected output to help us clarify your scenario.

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

[amitchandak]

@anithaMallam , You need to create a new measure % of total or use % of total option on the right click of measure 

Percent of SubTotal or Total: https://www.youtube.com/watch?v=6jTildcV2ho&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=37