Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
story | substory |
story1 | substory1 |
story1 | substory2 |
story1 | substory3 |
story2 | substory1 |
story2 | substory3 |
story2 | substory2 |
story2 | substory4 |
i want story name in KPI front end. which is having max no. of sub stories.
Thanks & Regards
Try this?
=FirstSortedValue(story, -Aggr(Count(substory), story))
Try this?
=FirstSortedValue(story, -Aggr(Count(substory), story))
What would you want to see if two stories have same number of substories? Would you want to see one of them randomly? You can try this
=FirstSortedValue(DISTINCT story, -Aggr(Count(substory), story))
See both separated by comma?
=Concat(DISTINCT Aggr(If(Count(substory) = Max(TOTAL Aggr(Count(substory), story)), story), story))