First you want to load both tables, flagging which data has come from where;
Data:
LOAD
'T1' as Table,
AREA,
ID,
VALUE,
BUSINESS
FROM C:\Users\MANOJKUMAR\Desktop\DATA.xlsx
(ooxml, embedded labels, table is Sheet1);
Do the same for Table 2, with a CONCATENATE (rather than a NOCONCATENATE as you presently have).
You can then create a table with VALUE and BUSINESS as Dimensions and expressions for T1 and T2 done with Set Analysis
sum({<Table={'T1'}>}VALUE)
and
sum({<Table={'T2'}>}VALUE)
You can then create a third column with the variance:
sum({<Table={'T2'}>}VALUE) / sum({<Table={'T1'}>}VALUE)
The colour you need to add to the Background Colour property of the third expression (by clicking on the plus symbol. The code will be something like:
=if(sum({<Table={'T1'}>}VALUE) <> sum({<Table={'T2'}>}VALUE)), rgb(255,100,100), null())
Hopefully that will give you what you need to make this work for you.
Steve
