thanks for the response
however, my use case is to display current value and average side by side in table or heat map
i think i need lod for this, i tried to build it but not successful
ideally i need
Current Value - Min - Average - side by side
Hello Chuck, not able to open workbook, it keeps saying there is an error.
Can you upload again or cut and paste logic?
BTW I am using 9.0