Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey, everyone!
I'm trying to solve this issue, but it's not working. see:
I have a Pivot table, where I have the total produced by machine and by product
Machine A | Machine B | Machine C | Total Per Product | |
---|---|---|---|---|
Product A | 59 | 47 | 79 | 185 |
Product B | 27 | 52 | 22 | 101 |
Product C | 26 | 12 | 55 | 93 |
Total Per Machine | 112 | 111 | 156 | 379 |
I want to show the respective percentage for each one of these (like that below):
Machine A | Machine B | Machine C | Total Per Product | |
---|---|---|---|---|
Product A | 32% | 25% | 43% | 1 |
Product B | 27% | 51% | 22% | 1 |
Product C | 28% | 13% | 59% | 1 |
Total Per Machine | 30% | 29% | 41% | 1 |
Can anyone help me, please?
Kind regards, Luiz Bisco
Check my response here: