topic Change the measure when using drill-down dimension in App Development

Change the measure when using drill-down dimension

Anonymous — Mon, 23 Jan 2017 04:31:36 GMT

Hi All,

Is it possible to change the measure automatically when using the drill-down dimension?

Best Regards,

Louis

Re: Change the measure when using drill-down dimension

jonathandienst — Mon, 23 Jan 2017 05:15:46 GMT

Yes - as long as the drill path uses fields, rather than calculated dimensions. Use GetCurrentField('drillGroupName') to get the current level of the drill down. Use this in your expression, like this:

=if(GetCurrentField('group') = 'Month', <expression for month>, <expression for other>)

In QV, the editor falsely flags this as an error -- I am not sure if the QS editor has the same flaw.

Re: Change the measure when using drill-down dimension

Mon, 23 Jan 2017 05:34:16 GMT

Hi Louis

Yes you can change the measure when using drill-down dimension but we have to mention what are he measure to be calculated in expression better use a set analysis for it