Forum Discussion
Can we compare values between two identical table and generate a new table with the differences?
I've attached the file with sample data, I'm okay with either a power query or a vba solution I have a total of two tables, 1: Minimum selling Price with just one fixed row 2: Price table, with ...
//select * from Sheet1;
cli_one_dim~Sheet2~1;
cli_one_dim~Sheet1~1;
create temp table aa as
select a.Client,a.属性,iif(a.数量<b.数量,highlight(a.数量),a.数量) Amt from Sheet2union a left join Sheet1union b using(属性) union all
select Client,'Total' 属性,sum(数量) from Sheet2union group by Client;
;
cli_create_two_dim_no_order~aa~属性~Amt;
select * from aa_two_dim order by Total desc;