I have 2 data sources of sales data. I did not merge the datasets so I have a sales data from one source and sales data from the other as two separate columns from two seperate tables. In data source 1, the customer's name and city are available. However, in Data source 2, there is no cusomter name information, I only have city and total sales. Is there a way when the 2 source of data are put into to a matrix visual to not show the exact same value when the data is from data source 2? So i still want the display to show a city level total for Data source 2 but not have that display for each customer since that data does not exist at the customer level in data source 2.
@bo_wang5 , Create a common city table and you can join both tables with that.
Also, you can create a customer table with additional row ( Enter Data, Append query in power query) having id -1 or name all , and add that as an additional column in not having customer(id _1 or Name all) .
Not join both table with customer and analyze the a data across.