Sometimes, when creating report, you need to display the values as a percentage. You can calculate percentages manually, and recently Excel also offers a PERCENTOF function to make this process easier. If you use functions such as GROUPBY or PIVOTBY, you can also use this function to calculate percentages when grouping values. Let’s see how we can use it!