Hi Diego medrano,
Thanks for ur Reply Mate,
I tried to replicate the formulae but its getting ""the formula must be an aggregate calculation or refer only to this field."
could u plz Elaborate the same in my attached .twbx workbook so that i can replicate the same i my workbook..
Still struggling to get this issue solve,
Note- there is no Category in my original data...(there is only SUB-CATEGORY in my original Data)
Hope u can solve dis issue..