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.
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 (http://www.cognoise.com/index.php?topic=11024.0)