SSAS 2016：在Excel 2013和Excel之间钻取不同的列顺序。 Excel 2016 [英] SSAS 2016 : Drill through column order different betwen Excel 2013 & Excel 2016

问题描述

亲爱的，

我在连接到SSAS 2016的两个Excel版本之间有不同的行为（表格）：

I have a different behavior between 2 Excel versions connected to SSAS 2016 (Tabular) :

- 从Excel 2013中钻取：在钻取XL表格中，根据表格设计器中的表格模型对列进行排序

- Drill through from Excel 2013 : On the drill through XL sheet, columns are sorted according to the table model in the tabular designer

- 从Excel 2016钻取：在钻取XL表格中，列按字母顺序排序

- Drill through from Excel 2016 : On the drill through XL sheet, columns are sorted according to alphabetical order

我们的用户更喜欢XL 2013的行为。你已经遇到过这个问题吗？你知道SSAS或XL方面是否有补丁来解决这个问题吗？

Our user prefer the XL 2013 behavior. Have you already faced this issue ? Do you know if there is a patch either on SSAS or XL side to fix this issue ?

谢谢！

推荐答案

您好Tiptip00，

Hi Tiptip00,

根据我的测试，我发现它会运行良好（我在Excel 2016中测试，我目前没有Excel 2013）

Based on my test, I find that it will work well(I test this in Excel 2016, I didn't have Excel 2013 currently)

 我的excel版本如下所示

 My excel version is like below

这篇关于SSAS 2016：在Excel 2013和Excel之间钻取不同的列顺序。 Excel 2016的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！