This content has been marked as final. Show 4 replies
You can use Column Selector with Prod Category and Prod Sub Category as choices. Then put this column group into Y axis.
you need to edit the graph properties and select the column which you require in the x/ y axis.
And as mentioned above, use a column selector to change the columns.
Hope this helped/ answered
Thanks for your reply.
But there is a constraint option in prompts.for ex:in 1st prompt if i choose prod.category then prod.subcategory prompt sholud display the values which are related to first prompt value.
we cant achieve this functionality with column selector.
Prompts are used for filtering the report and Column Selector provides the choice of columns which you want to slice the measure by.
If you want to use only one of the column in Y axis at time, you should add column selector.