Forum Discussion
need help
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
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.
2 Replies
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
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.
