Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
-
Re: How to parameterize with detail report in column value
In the "Direct Reportees" analysis, add "Manager ID" as a prompted filter.2 -
Re: Can you filter the MAX of a data set that uses RCOUNT and FLOOR functions
Many of the regular aggregation functions (as opposed to the running aggregation functions) can use the BY keyword with a list of columns. Here are examples: COUNT( DISTINCT "Form Type" BY …2 -
Re: Is it possible to create a calculation in which part of the calulation isnt affected by an attribute
Sorry, LukePa. Since you wrote "dashboard filter," I assumed you were using classic, which includes dashboard prompts. In your case, it has to be a parameter, not a variable. The parameter …1 -
Re: How to build a one table to show data from two different datasets in workbook.
Hi @Rajakumar Burra , I recommend you create calculations for Vendor and Quarter using the IFNULL() function, like this: Then you can use this calculated Vendor and Quarter in your pivot table.1 -
Re: Table Suppressing Rows | Excel/PDF Export
Vismay, Check the setting, "Repeat Rows on Excel Exports for Tables and Pivots," in the "Other" section of System Settings.1
