Rank with partitioning - MDX
Rank on grouping
Recently I got a problem of ranking based on a group.Lets try to solve the same problem using Adventure Works cube.
We have details of customer country and customers. We want to rank them based on their internet sales. But we want the rank to be reset when the country changes. In general rank will assign rank in ascending order , but we want to reset it when the country changes.
Tags: mdx