Last updated on MARCH 31, 2017
Applies to:Business Intelligence Suite Enterprise Edition - Version 126.96.36.199.160419 and later
Information in this document applies to any platform.
Customer reported the issue with thousand separator using the Pivot table in the report, if that column (and report) is from Logical Dimension table and aggregated in pivot view – even ‘Use 1000’s Separator’ check box is selected in the column properties
Changed the datatype to other than Integer eg., Double, Char Apply the aggregate function (like Count) on the column’s Aggregate Rule selection in pivot view Run the report. Then pivot table is not displaying thousand separator If I apply aggregate function in the column formula section in the Criteria tab with default selection in column’s Aggregate Rule in pivot view, then pivot table is displaying thousand separator
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms