You should be able to make a Median measure, the only suckful thing is that you need to i) tie it to a set (e.g. 'Enterprise and Users') and ii)...

I think it depends on what version of excle you're running but on my 2010, if you right click the pivottable and select pivottable options, on the display tab you...

Mark,

As far as I can tell, your last attempt should give you the result you want. As far as making the result visible, try using the ADDCALCULATEDMEMBERS function on...

or is the struggle more that there is no 'else' written there, you have to search (visually) for the colon? It's a bit of a PITA, and would be...

The else is the right hand side of the colon

booleanexpression ? trueexpression: falseexpression

so what I might write in vb or similar

If today = "friday" Then

"happy days!"

Else

"week...

I could have sworn there was a case or switch statement, but you could always do the poor mans way - string together a set of IF statements.... format...

Sounds like an OK approach. The only potentially tricky part will be in the usage of the parameters as you'd outlined. Basically it sounds like the final query...

Great idea Lutz, would likely help out.

While you're looking at posting that file, I think you'll find that the problem is that the xml generated is in the form of

NodeA_1

...

Can you post the error? Without seeing that it's very hard to determine what might be missing/needed. If you could also post a small part of the...

It *should* be as easy as creating a new parameter and then cascading it's contents to the second parm (the one which has a DDL).

Being a little more specific, you...

Not possible out of the box with SSRS. To have the 'intellisense' or 'auto-complete' style functionality in a DDL you need like javascript or equivalent, where the current text...

Not sure I follow your train of thought... Yes, people like to read XML when it's formatted but there is no requirement for it to be formatted. Like...

If you can't/won't use a view, why not use the DSV approach? A little known feature (well, little known *to me* 🙂 ) is the ability to reference a...

If you've already got a process updating the dayspassed, is there any reason why you can't change your fact to a view, and simply bring the dayspassed into the fact...

@Baddog - the intent was to create a set, not so much as part of the calc meaure but standalone, for use in (one or more) calc measures. Am...