Could you include a workbook please?
This is tricky one.
I created parameter
[Rank]<= [TOP N] or last() = 0
if [Rank]<= [TOP N]
else running_sum(if [Rank]>[TOP N] then sum([Sales]) end)
TOP3_9.2_SM.twbx 21.2 KB
Could you please post the logic of TOP N Name (Calculated Field)
For some reason, I am getting last as other values(products in the example) that is not Other
Do you know why is happening?