Calculating percentages is useful when you want to see, for example, the percentage revenue generated from each channel (online, stores, partner, etc.).
Here is a common percentage example:
The following example shows you how to figure out the percentage revenue generated from each channel (online, stores, partners, etc.).
- Create the following formula in the Formula Builder, percent revenue = ( sum ( revenue ) / group sum ( revenue ) ) * 100.
- Now you can search by each channel, using the percent revenue formula that you just created.