hi there,
some one please help with the issue. i dont want multiple times exceed how to eliminate it.
instead of multiple times i want only one time.
i'm attaching work book and screenshot as well.
thanks in advance.
this is a bit of a hack
you have something in the data that results in multiple records at the combination you are trying to show
this lod will return the min (exceed is < normal because e<n) and you can apply it as a discrete value on rows
you need to convert the chat to text and blank out the columns with a blank ( ' ' )
don't know where all the multiples are coming from but you would - it is in the data
Jim
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
