Forum Discussion
Max Value based upon two column and content.
TYPE ACTION MODIFICATION DATE ITEMS SPLIT_MOD Expected WIDGET-A BASE 1-Dec-24 57 0 WIDGET-A 56 WIDGET-A ADD BASE 1-Dec-24 57 0 WIDGET-B 75 WIDGET-A CH...
HI CScottP,
Did you mean only use the 'TYPE' fields to get the aggregate value from the ground detail records?
If that is the case, I'd like to suggest you create virtual table in variable and lookup value from this variable table based on current row contents.
All the secrets of SUMMARIZE - SQLBI
Regards,
Xiaoxin Sheng
How can I add a filter sequance "ACTION" with the following order:
Add, change from, no change, change to, and delete, I created "SPLIT_MOD" column value to show latest Add, change from, no change, change to, and delete in a sequance.