Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I need a formula to calculate and visualize percentage on sales. The following is my raw table:
Code | Date | Category | Amount |
A-0001 | 1-Jan | Sales | 800 |
A-0001 | 1-Jan | Sales | 300 |
X-0002 | 1-Jan | Direct Cost | 400 |
C-0003 | 1-Jan | Expense | 250 |
C-0003 | 1-Jan | Expense | 300 |
A-0001 | 21-Feb | Sales | 500 |
A-0001 | 21-Feb | Sales | 300 |
X-0002 | 21-Feb | Direct Cost | 400 |
C-0003 | 21-Feb | Expense | 100 |
C-0003 | 21-Feb | Expense | 100 |
Expected result
Thank you.
Ardie
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.