当前位置: 动力学知识库 > 问答 > 编程问答 >

excel - CUBEFUNCTIONS: Retrieve a column value based in another

问题描述:

I am using a data model with Power Pivot:

The first column is called "Description" and the second column is a RANKX function based on a third column. I want to use Cube functions to get the TOP 10 descriptions based on the ranked on Excel.

With this formula I get the top 10 fields from the ranked column:

=CUBERANKEDMEMBER("ThisWorkbookDataModel","[Query1].[Ranking].[ALL].Children",ROW(A1))

And I have the ranking top 10 if I drag the formula 10 cells:

How can I get the descriptions based on that column with cube formulas?

分享给朋友:
您可能感兴趣的文章:
随机阅读: