Hi All,
First post on the community site for me, I have a straight table showing the largest 10 values and everything else grouped in others, the single dimension I have is called 'Brand', I'm trying to show the top 10 performing brands but there are also many unbranded entries which are marked with '#' , the cumulative value of these means that they are ranked Number 1. Is there a way to move all entries where the Brand is '#' to be calculated under 'others'?
Many Thanks,
Hareesh