Hi All
I have a requirement where i need to compare the data from one category with another category and display rows only where there is a change. However display with the new data only. And this is for 12 months of data. So even if single month changes i need to show that as highlighted one.
Example:
Table A / Table B : Table A and Table B are loaded as separate tables.
Col1 , 2 , 3 are the base columns for which there will be a HCM value for 12 months Jan to Dec. in both tables A and B.
TABLEA
| ACol1 | Col2 | Col3 | DEC | JAN | FEB | |
|---|
| A | B | C | 2 | 4 | 6 | | |
| | | | | | | |
| D | E | F | 3 | 2 | 7 | | |
| G | H | I | 2 | 3 | 3 | | |
| | | | | | | |
| | | | | | | |
| | | | | | | |
TABLEB
| ACol1 | Col2 | Col3 | DEC | JAN | FEB | |
|---|
| A | B | C | 5 | 4 | 6 | | |
| | | | | | | |
| D | E | F | 3 | 4 | 7 | | |
| G | H | I | 2 | 3 | 3 | | |
| | | | | | | |
| | | | | | | |
| | | | | | | |
RESULT: Row 1 and 2 are shown and the one which has changed value is highlighted. Note I do not need the difference , but where there is a difference i need the value from Table B. Like 5 - 2 > 0 , so show 5 from table B. Please let me know which is the best approach for this either via formula in Pivot table or via script or any other simple method.
| ACol1 | Col2 | Col3 | DEC | JAN | FEB | |
|---|
| A | B | C | 5 | 4 | 6 | | |
| | | | | | | |
| D | E | F | 3 | 4 | 7 | | |
| | | | | | | |
| | | | | | | |
|
