Could you please share the workbook with me?
1 of 1 people found this helpful
Workbook is already attached. Please go to main thread, not in email. and if it Helps, Please mark it Helpful and CORRECT to close Thread.
Thanks Deepak. This worked as expected.
I have a little enhancement to this one.
Compare multiple set of columns like above. I created multiple calculated columns like in the workbook attached by you. But the thing is the alignment. I am not able to align it in the form which is in the screenshot. Alignment meaning the order of columns which is required.
Formatting Takes care of alignment. You can Format each Measure individually. Click Format then from Choices Select Alignment and Select what ever is needed.