Sorry i'm not sure what the Question is then? Is you use say "conitains all" - then wil be displayed as below - you can't change this as that is the functionality of the product

Hi sounds like in the opeator for the prompt you have "contains all" instead of Equal to/Is in. Amend the prompt and change it to what is required

hi i've used your XML and just changed it so it works with our elements/input values and the totals are all correct, so not sure why its not for you. In your pivot table, try changing the aggregation rule to a different option (eg server complex etc) and see if thats fixes it. Other suggestion would be to only include…

hi could you share a screen shot of the current output, what the issue is with it and then say an excel table of what your desired output is? It sounds like you only want to display input values for specifc elements?

I've just updated the same question on https://community.oracle.com/customerconnect/discussion/comment/1236302#Comment_1236302

hi it doesn't matter where it is positioned on the dashboard - the prompt column needs to be as a filter in the analysis for it to pass through. ie If your prompt is on the column "journey name", then in your analysis apply a filter "Journey name is prompted"….then then value from the prompt will pass through. Note - even…

Have you tried anything ? Looked at the Case statement? case when Ethnicity like '%Hispanic%' then 'Hispanic' else Ethnicity end

so if category is GP Budgeted , return the Classification name. if thats what you want, then yes seems correct Is it giving you what you want?

Yes i know - above is for OTBI. So create a simple otbi report and get it working like my example above, then add the rest of the detail you want one by one…

Don't thnk there is an easy option. Could maybe do a Union to return custom headers as a "data row", then format that row. Select 'heading1' , heading2'… union select data1, data2 Other option is if Edit formula for each dim/measure and provide the required "Folder headings" to group them together. In the table view >…

Start of with a basic table and get it working, then add in the other dimensions one by one….there must be something causing an issue

Make sure rhe Dimension Class Category isn't in the table, then it will aggregate up and make sure the Aggregation of the measures are set to sum. My simple Example:

yes plenty examples on here -Just create a CASE statment for each one you want case when Classcatgory = 'A' then value end case when Classcatgory = 'B' then value end

Have you amended the formula? create a new report without amending anything > create a pivot table > make sure it is aggregating up > then once that is working can then use the case statement to amend the output

the cog next to the measure

The pivot table should aggregate the data. So you should just have 2 rows for public hol and. regular - but you are getting multiple rows so its not aggregating. Just put payroll type in the row, date in the col, hours as the meaure - then check the aggregation of the hours - click on the cog - try setting it to sum. The…

youve still not provided your desire output. put the table in excel and show how you want it to be in the report

So you no have 4 rows instead of 2, so your orig pivot table was aggregating values. Can you share the output how you want it to look pls

Add payroll time time into your output, so its clear what it is - once know what it is returning, can then work out the correct case statement

Also the intial case statement is incorrect If "Payroll Time Type Name" = 'Public Holiday IN', then this is satisfied by the 1st "When" condition: "WHEN "Reported Time Entry Details"."Payroll Time Type Name" = 'Public Holiday IN' THEN 'PH'" ie it will return "PH", so it will the 2nd condition will never be met because…