i am using obiee 12c. i am trying to display data for all columns values for pivot table prompts column. but when i add column in 'pivot table prompts' by default its taking first row value and filtering whole report based on that value. anyone suggest how can a achieve displaying the data for all column values without using the dashboard prompt.