Comments
-
Hi Mark, Thanks for your reply. I have sales and cost in same columns. Now how to do it. I have many similar cases. Particulars Amt Sales 100 Cost 70
-
Dears, Can anyone help me to create formula under calculated field under pivot table chart. Attached excel file for your reference.
-
Calculated field will help to create new column. But I required new row with existing rows. Row 1 should have Sales Row 2 should have Cost Row 3 should calculate based on Row 1 and Row 2. Attached the sample file.
-
Hi Pauljames, Thanks for your clarification. Could you please help me to show the formula to be created under Calculated field.