Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
I am wondering how to achieve the below desire result by using Aggr function? Thank you..
Data:
Model Status Seq No Criticality
A WIP 50 High
A Blocked 51 Medium
B No Resource 60 Medium
B Blocked 61 Medium
C WIP 65 High
(Show the result according to the minimum "Seq No" +"Model" grouping . For the Status, Only "High Criticality" will display the Status.)
Desired Result:
Model Status Seq No Criticality
A WIP 50 High
B 60 Medium
C WIP 65 High
may be
Dimensions
**********
1) Model
2) Status
3) Criticality
Measure
*******
Min([Seq No])
Hi Carlos,
Try this in the front-end. This will also work of you have multiple High's and multiple Seq No's.
For your measure:
IF(Criticality = 'High' OR [Seq No] = Aggr(Min([Seq No]),Model),1,null())
For your dimension:
IF(Criticality = 'High',Status,null())
Make sure you have the option: Add-ons --> Data handling --> Include zero values, unchecked.
I've added one more example to show that it works.
Jordy
Climber