Hi Andrew, I forgot to mention, i was working on top 10 and others report in the pivot table. In that case i was not able to remove the subtotal from the pivot table percentage column. In normal pivot table, i was able to remove subtotal for the percentage metric by using aggregation none option for the percentage metric.…

Hi Manoj, One thing i forgot to mention is, i was doing top 10 and others report in pivot table. In this case, the data was disappearing when i selected aggregation none in the pivot table for the percentage metrics. for the same report, i moved the percentage column to the rows section in the pivot table and have…

Hi Andrew, Yes please. I wanted to display all the columns subtotals in a pivot except for the percentage column. may i know which version of the obiee were you using?/ What did you do to achieve this. Regards, Kalpana

Hi Gianni, Thanks for the reply, it worked . I am marking your reply. Regards, K

Hi Manoj, Yes i did, it doesnot display any data. Regards, K

Hi Christian, True, I figured out the same while trying different options in the report.Thanks for your reply.I have implemented this and it works fine. I am marking your answer. Regards, K

Hi Srini, I cannot use the presentation variable in the report level. I need to use them in the column formula only. Is there any way for this ? Regards, Kalpana

Hi, I am able use the ifnull condition and display all column values. what would be condition to display only the selected values. case ifnull('@{pv}{A}','check') when 'check' then 'display all column values' end - displays all values can anyone help please.

Hi Srini, Thanks for the reply. I just set the width of the section and it worked.I am marking your answer as it might work for reports . Regards, K

Hi Gianni, Thanks for the reply.However, i still face some issue with the condition. This is my condition. case when region='@{reg}' then filter(paint.sales using ((category IN (@{pv}['@']{'TV'}) OR category IS NULL)) when region='@{reg2}' then filter(paint.sales using ((category IN (@{pv}['@']{'TV'}) OR category IS NULL))…

All Column values passes null value to the report. For my requirement, i could not use it.So, altered prompt and removed all column values choice.

Hi Cesar, I am using the around 5 presentation variables in each column formula in my union report for calcualtions.I cannot use them at report level in the filters. The obiee version is 11.1.1.7.141014 (Build 140916.0744 64-bit). Thanks, K

Hi Gianni, The report works fine in normal report, the issue is coming up in the union report only. Thanks, K

Hi Gianni, I have checked with the Apply button too, but it doesnot help. I still need to refresh the report to get the data. any other suggestions please. Regards, K

Anyone?

Hi Adrian, In my union report, the first report only has the top 10 and rest others in first report and the second one. can you please let me know in detail of achieving this please. Thanks, Kalpana

yes Manoj, if i get -1 right i can use the same for -7.

Hi Thomas, I have dashboard prompt on Date. When the user selects the date, I need to calculate previous day and -7 days and use both of those days to perform calculations in the report. Can i use request variables for doing this?. I dont have time dimension hierarchy. I just have a date column and i have to use it for…

Hi Cesar, Thank you. Right now i implemented 1 to 3 in the same report and 4 and 5 in a separate report. I still need to work on the report. Regards, Kalpana

Thanks Ceresa, I think i should stick to my javascript solution for this