Hello All,
Basically i have 4 dimensions: Batch, SKU and KPI(Delivered on-time) and status
I'm trying to pull up analysis in which I want to show information at SKU level. What i want to present is in simple graphs which materials had batches on-time delivery KPI of 50% or more but only for Status 'Closed'.
My challenge is
1) How can i aggregate this at SKU level so that I can show by region how many SKU's are delivered with 50% or more on-time service but only for 'closed' status.
2) How can I create a new dimension with Values ( >50% On-time and <50% on-time) which I can use as filter so that I can split and view list of SKU's. Only till SKU level and not at batch level
| Batch | SKU | Delivered on time | Status | Region |
| cdxf | 1 | yes | Closed | America |
| sd | 1 | yes | Closed | Latam |
| ddff | 1 | no | Closed | Asia |
| ggtg | 1 | - | Open | America |
| rrtgh | 2 | yes | Closed | Latam |
| sdews | 2 | yes | Closed | Asia |
| swdfg | 2 | - | Open | Asia |
| qaser | 2 | yes | Closed | Latam |
| lkpj | 3 | no | Closed | America |
| ngjg | 2 | no | Closed | Asia |
| ddfyk | 3 | no | Closed | Latam |
| fgjyl | 3 | yes | Closed | America |
| rtryty | 4 | no | Closed | Asia |
| tyu | 4 | yes | Closed | America |
| fghyyj | 4 | yes | Closed | Latam |
| rtgy56 | 4 | no | Closed | Asia |
| tgy77 | 4 | - | Open | Asia |
| 34rfth | 4 | - | Open | America |
| 5ty67 | 4 | - | Open | Asia |
