HELLO,
I have Pivot chart where in Company as a dimension and a cyclical drill(Company,brand, and two more dimensions) the problem is i want to display ranks .................in expressions i am analysing financial year wise sales ...the problem arises that the rank is not displayed properly..
the problem is company may have different rank and brand may have different for
eg Reebok may be no1 cmpny sales wise but its certain brand of shoes rank 10th as it sales rank so can i display both ranks differently
so how do i overcome this problem