Forum Discussion
Store Rank
Hi All I want to create a dynamic column that keeps track of a number of ranks for a store . Then i can create a drill down page into a trophy case of sorts , so im thinking when drilled dow...
Rank has to be based on certain base value . for example based on sales I want to Rank the Promotions
Rank = RANKX(DimPromotion,[Total Sales])
you can create the column which is dynamic in nature based on the chnage in the sales value (for above example)
you can create the column which is dynamic in nature based on the chnage in the sales value (for above example)