Filtering crosstab with nested rows on a user entered measure value.

[cognos4321]

Hello experts,

I created a crosstab report with nested rows and measures.
Now user wants to enter a value(text box prompt) for a specific existing measure and filter the rows based on condition (less than the number entered).

I thought adding query calculation in place of the measure and then putting a filter expression would work but how do I do that for nested rows.

Please suggest how do I filter the crosstab with nested rows based on an existing measure where the user wants to enter the measure value as a prompt and wants to see all rows where the measure value is less than the number entered.

Datasource is TM1 cube.

Thanks a lot in advance.

[New_Guy]

Hi,
You have to use tuple and filter functions to get the members based on the prompt, filter(members, revenue > ?p_user_entered_value?). Please refer to the below post.
Good luck
New guy

http://www.cognoise.com/index.php?topic=11024.0