Report Portal

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.

Read more...

 

Tags: mdx

 

2007-2015 VidasSoft Systems Inc.