# Percentage all rows of one specific row in that day

I have in data multiple calculation per day and in each day there is also value that is sum of all. How can i calculate this percentage value like in this table:

``````
+------------+----------+-------+------------------------------------------------+
|    date    |   name   | value |                   percentage                   |
+------------+----------+-------+------------------------------------------------+
| 01-01-2023 | name1    |     1 | name1 value / specific value in that day *100% |
| 01-01-2023 | name2    |     2 | name2 value / specific value in that day *100% |
| 01-01-2023 | name3    |     3 | name3 value / specific value in that day *100% |
| 01-01-2023 | specific |   120 | specific/specific *100%                        |
| 02-01-2023 | name1    |     2 | name1 value / specific value in that day *100% |
| 02-01-2023 | name2    |     2 | name2 value / specific value in that day *100% |
| 02-01-2023 | name3    |     2 | name3 value / specific value in that day *100% |
| 02-01-2023 | specific |   300 | specific/ specific *100%                       |
+------------+----------+-------+------------------------------------------------+
``````

My problem is how to select name row with value ‘specific’ for each day.

1 Like

Hello @koot - Thank you for posting your query. This can be done by creating a new calculated field. Please find the below snapshot where I have tried to explain how you can implement the calculation to achieve what you are trying. Hope this helps!

Did my suggestion help you in resolving your query? If yes, would request you to mark the post as “Solution”. This will help the community to find guidance and answers to similar question. Thank you!

1 Like

Thank you very much @sagmukhe for your help

1 Like