Can any one tell me how to use Rank function in dimension of pivot table to show top Brands.
As shown in attached screen shot in first column there is a cyclic drill having fields 'Country' and 'Nil' where nil is blank.
If I select 'Nil' in first cyclic drill then it should show top brands of all countries as shown in fig 1
And if I select 'Country ' in cyclic drill then it have to show country wise top brands. ex. As shown in Fig 2 in USA there are five top brands A,B,C,D,E
