MDX Query help in Report Studio

[jehjasjes]

Hi,

I am having a dimension called Company as the page layer.

Based on the company selected, I want to update a cell with same company name which is selected.

I tried using query calculation so on. But nothing worked.

Could somebody suggest a solution.

Your help is much appreciated

Kind Regards,
JG.

[MFGF]

Hi,

I'm not quite clear on exactly what you are trying to achieve.  When you said "Based on the company selected", does this imply you have a prompt for Company?  Or do you mean you want to get hold of the Company value used in the current page?

When you used a Query Calculation, what expression did you use?  What error(s) do you get?

MF.