Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.