Calculate the total of a table by with Measure

YingFa

Board Regular
Joined
Nov 4, 2019
Messages
63
Hello,

I am trying to calculate the total of a table by entering a measure instead of the automatic total that the table gives by default. Please see attached image.
Is it possible to use "New measure" to calculate the total at the end of the table instead of this being calculated automatically by the table. The numbers at the top of the table are total per line for each day.

Thank you.
 

Attachments

  • PB Table.png
    PB Table.png
    5.8 KB · Views: 12

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".
Can you explain the problem more completely? I don’t understand what the issue is

Hi Matt,

Thank you for your reply. Yes, the issue is this, the table that you see attached in my first post is the daily hours of 3 lines. I would like to calculate the efficiency of it. Meaning, total hours per day/(number of lines*7.5hours). and I would like this result to appear at the bottom of the table for every day when I upload the hours of each line. But I do not know how to do this? Do you think it is possible?
 
Upvote 0

Forum statistics

Threads
1,223,762
Messages
6,174,353
Members
452,557
Latest member
savvaskef

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top