What specifically wasn't working for you? I opened your workbook and created a field using your formula (Calculation1). Then placed it on the worksheet as an attribute.
Is the attached what you are looking for? If not please let me know and I will continue to assist.
Superstore.twbx 308.6 KB
you can solve your issue in two way.
1) Approach 1: Drag the calculated Field into the row shelf and then right click on Arrow sign and select attribute.
2) Approach 2:Uncheck the Aggreegate measure (Analysis->aggregate mesaure)
Please let me know if you need any more information on the same.Please mark the answer as correct if it solves yoru problem.This will help other members when they are searching for solutions to similar problems.