Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
I have a set analysis with two conditions: One it has to be grouped by "Group Bracket" = Order
Second condition - show the top 10 brand corresponding to the different brackets.
Calculationnr is a distinct value so I want to count how many times it occurs by group bracket (top 10).
Do you have any idea what I can do to show the top 10, because now it shows me the top 20 +.
Formula I want to adapt.
Count({<[Group Bracket]-={"*Order*"}>+<[Brand] -= {"=Rank(Count([Calculationnr])) <=10"}>} Brand)
Never mind Count({<[Group Bracket]-={"*Order*"}>+<[Brand] -= {"=Rank(Count([Calculationnr])) <=10"}>} Brand)
Is the right formula, I did something wrong in my comparison.
Never mind Count({<[Group Bracket]-={"*Order*"}>+<[Brand] -= {"=Rank(Count([Calculationnr])) <=10"}>} Brand)
Is the right formula, I did something wrong in my comparison.