Aggregating one level above and applying conditional analysis
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
