Cubeset和Cuberanked与Slicers？ [英] Cubeset and Cuberanked with Slicers?

问题描述

我有一个按国家和产品销售的数据库。我想按产品创建一个报告，按照国家切片机的降序排序。


$
当我点击某个国家/地区时，我希望看到按降序销售的产品。


$
我在整体水平上使用了立方体和多维数据集排名成员，但我不知道如何制定报告以便成为基于切片器中选择的国家或地区的动态。



= CUBESET（"ThisWorkbookDataModel"，"[DB]。[Product] .children"，" ;排序"，2，" [Measures]。[TotalSales]"）

= CUBERANKEDMEMBER（" ThisWorkbookDataModel"，$ F $ 1，E11）...

          $ F $ 1是我有多维数据集的单元格。
           E11是我的排名编号

请注意，我不想做数据透视表，因此有一些原因不能作为选项。

赞赏任何支持。

Xavier Guillaumin

解决方案

您好  Xavier

你说你不想创建数据透视表，你想用什么工具？如果可能的话，您能告诉我更多详情（例如您的数据和期望的输出）吗？然后我会更正确地帮助你。

最好的问候，

Zoe Zhi

I have a database with Sales by country and products. I want to create a report by product sorted in descending order with a Country Slicer.

When I click on a country I want to see the products that are sold in descending order.

I have worked with the cubeset and cube ranked member at total level but I don't know how to formulate the report in order to be dynamic based on the country or countries selected in the slicer.

=CUBESET("ThisWorkbookDataModel","[DB].[Product].children","Sort",2,"[Measures].[TotalSales]")
=CUBERANKEDMEMBER("ThisWorkbookDataModel",$F$1,E11) ...
          $F$1 is the cell where I have the cubeset
          E11 is where I have the rank number

Note that I don't want to do a Pivot Table, there are some reasons for this not to be an option.

Any support is appreciated.

Xavier Guillaumin

解决方案

Hi  Xavier

You said you don't want to create Pivot Table, what tool did you want to use? So if possible, could you please inform me more details(such  as your data and your expecting output)? Then I will help you more correctly.

Best Regards,
Zoe Zhi

这篇关于Cubeset和Cuberanked与Slicers？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！