Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all - hopefully a basic one!
I have the following Pivot Table
Serial Number | Consumable | 06/12/17 | 05/12/17 | 04/12/17 | 03/12/17 |
---|---|---|---|---|---|
123456789A | Part 1 | 26% | 31% | 32% | 32.5% |
Part 2 | 65% | 65% | 71% | 72% | |
Part 3 | 12% | 16% | 42% | 54% | |
EIT999101012 | Part 1 | 29% | 33% | 33% | 41% |
Part 2 | 99% | 99% | 99% | 99% | |
Part3 | 75% | 77% | 79% | 81% | |
XYZXYZTUITI123 | Part 2 | 43% | 47% | 52% | 55% |
CYNCYNCYN101 | Part 1 | 99% | 100% | 100% | 100% |
Now I want to display this as a burndown chart so we can try to predict when they will hit 0%
How would I get this to display as just now they keep grouping into Consumable Parts?
I've had to enabled some If Statements to ensure the different unit types come out as a Percentage.
Any help would be appreciated!
Cheers
Craig
Sorry should have said!
I'd like the Percentage to be the burndown, but showing how a certain Serial Numbers Consumable is going.
Then I can do a report of what Serial Numbers have a consumable with a low percentage.
It might be easier if you could share a sample to look at this?
Hi Sunny, cant share as it contains customer / supplier data. Sorry
You can scramble the data and then share?
Preparing examples for Upload - Reduction and Data Scrambling
This is what currently is produced, but those lines are just consumable numbers only.
I don't want the client to have to add a filter of the serial number as they would rather only see data less than 25%