在MDX中计算一组度量的YTD？

问题描述

我的要求是：我需要根据用户的度量选择显示YTD  ，当用户根据该度量拖动任何度量时，应该计算YTD。

示例：

WITH MEMBER [Measures]。[Current YTD] AS

SUM（YTD（[Date]。[Calendar] .CurrentMember），[Measures]。[Internet Order Quantity]）  from
Cube

而不是 此措施  [Measures]。[Internet
订单数量]，当用户拖动另一个/任何小节时 基于该度量根据用户选择动态填充YTD值。

你能帮我解决这个问题吗？

在此先感谢

---

Siddanth

解决方案

My requirement is: I need to show YTD based on the measure selection by user  , when user drag any measure based on that measure YTD should be calulated.

Example:

WITH MEMBER [Measures].[Current YTD] AS
SUM(YTD([Date].[Calendar].CurrentMember), [Measures].[Internet Order Quantity]) from Cube

Instead of  this measure [Measures].[Internet Order Quantity] , When user drag another/any measure based on that measure dynamically populate the YTD values based on the user selection.

Can you help me out on this?

Thanks In Advance

---

Siddanth

解决方案

这篇关于在MDX中计算一组度量的YTD？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！