Sitemap

Amicuk Programming Answers

Decimal Places in Pivot table

2015-10-11   Views:1

Advertisement

Hi Gurus, When I create a pivot table with a measure and I choose "Show Data as ... percent of something (for example section) I get the result with 1 Decimal Place. How to modify it for 2 or more Decimal Places? Thanks LaszloHi Laszlo! We have found

Hi Gurus,
When I create a pivot table with a measure and I choose "Show Data as ...
percent of something (for example section) I get the result with 1 Decimal Place.
How to modify it for 2 or more Decimal Places?
Thanks
Laszlo

The replay answer
Advertisement
Hi Laszlo!
We have found and discussed the answer already, but to more people can see it I write it.
When You have the results already, You can use the 'Advanced' page to see the XML source. There you can modify the code carefully. Change the section:
<saw:dataFormat xsi:type="saw:percent" minDigits="2" maxDigits="2" scale="2"/>
Change maxDigits to the number of decimal digits You wanted.
Although we found the answer on the course, I found later this page - also could help:
http://blog.trivadis.com/blogs/andreasnobbmann/archive/2008/07/15/quot-percent-of-quot-in-obiee-s-pivot-tables.aspx
Best regards,
Tamas

Go to See the other 2 answers

Decimal Places in Pivot table

Category:DefaultRelease time:2015-10-11Views:130

Hi Gurus, When I create a pivot table with a measure and I choose "Show Data as ... percent of something (for example section) I get the result with 1 Decimal Place. How to modify it for 2 or more Decimal Places? Thanks LaszloHi Laszlo! We have found[More]

Mimic "show data as percent of row parent" in non-pivot table

Category:DefaultRelease time:2015-10-11Views:130

Is it possible to implement or mimic the 'percentage of parent row' functionality, foreseen for pivot tables in obiee 11g, for a 'normal' table? We use a rather fixed table, in which no drilling is allowed - conditions are applied by means of prompts[More]

Data format in pivot table calculated item

Category:DefaultRelease time:-0001-11-30Views:130

Hi All, I've got a pivot table with a dimension on rows and a dimension on columns and a measure. I have a "new calculated item" based on the dimension on the columns which does the following: ( ($2-$1) / ($1) ) *100 I want this calculated item[More]

Formatting metrics in a pivot table differently based on a unit of measure

Category:DefaultRelease time:-0001-11-30Views:130

I have a generic metrics table with columns for METRIC NAME, UNIT OF MEASURE, ACTUAL VALUE, BUDGETED VALUE, and PRIOR YEAR VALUE. Each metric has a unit of measure associated to it, and I need to be able to format these metrics differently in the sam[More]

Access Pivot Table truncates sums

Category:DefaultRelease time:-0001-11-30Views:130

I use Pivot Tables in Access 2007 a lot and discovered recently when trying to tie out the results that when the raw data has decimal values, as in a currency format, the sum function in the pivot table is truncating the results to a whole interger. [More]

Conditional formatting on total cells in pivot table

Category:DefaultRelease time:-0001-11-30Views:130

Hi, i have a pivot table with some values and percentages. The percentages are in red if less then 0. I have 1 row and 1 column of total values, but this cell aren't red if percentage is less then 0. Does anybody know a solution for my problem? Thank[More]

Division between two columns in pivot table in Answers

Category:DefaultRelease time:-0001-11-30Views:130

Hi all In answers if I have two columns in my pivot table say column A and Column B, how can I use a division of Column B by Column A to derive Column C. I am unable to do that using the "New Calculated column feature" or in the criteria section[More]

IF statement in Calculated Field for Share point, doesnt calculate sum in my Excel Pivot table.

Category:DefaultRelease time:2015-10-11Views:130

Hi Everyone I used this in SP calculated column field. =IF([Shift Sched]="1pm to 10pm","0",IF([Shift Sched]="2pm to 11pm","1",IF([Shift Sched]="3pm to 12am","2",IF([Shift Sched]="4pm to 1am&[More]

Can any one tell how to create pivot table

Category:DefaultRelease time:2015-10-11Views:130

Hi , Am trying to create a pivot tabel in the MDM Import Manager. Iam able to see the preview of the pivot table which i want to create. But when i try to click "OK" button, an error message getting displayed like... "The new table cannot b[More]

Can I 'explain' data in a pivot table?

Category:DefaultRelease time:2015-10-11Views:130

Hi All. I have a request that has baffled me. I need a way to use 'text' to describe the results of a report. If I were doing a simple report, this would be a non-issue. Here are my hurdles: I have a report that uses a Union via Set Operations (so I'[More]

Not able to see data in Pivot table

Category:DefaultRelease time:2015-10-11Views:130

Hi, I have a issue with pivot table i have a column which displays values 0 and 1 and another column called month when i am placing this month column as a section and values column as a measure i am not seeing any values means i can see the month as[More]

Hot
Hi all, I have my Satellite U400, I created the recovery DVD and I used two or three times to restore my system. But now I tried but always failed during the installation, I think some of the restore files are corrupted and can't be coppied to the co [More]
How to get all INDEXes in a database? I need to store them in script file (.SQL). My database version is 10.2.0.3.0. Edited by: Iniyavan on Sep 18, 2009 1:39 PM--Thanks, Koppelaars. The second query works. But I'm unable to store in spool file. May b [More]
Dear Guru's, I have to restrict movement type 311 on some storage location for some user ID.Following is already done but not able to restrict the movement of material on other storage location rather than defined: 1) Maintained authorization objet M [More]
I'm using the helpfile example to "Create a table that grows using the button object" and when I get to point about adding script to the button object's click event, I select JavaScript as the language and add: Table.Row1.instanceManager.addInst [More]
My husband wants to play, I do not wnat to pay.Perhaps your husband should search the App Store and sort by price?Read other 2 answers [More]
I am unable to upload documents.Currently the only supported Firefox versions are 7.0.1 and 3.6.23 Other versions including 6.0.2 have security vulnerabilities and are not recommended. You can install the portable Firefox 3.6.x version to access webs [More]
Hi, my hard drive has blown up so I have installed another. However during the instalation of OS X Tiger it will lock up very near the beginning of the installation process and gives the following error message. Installer Failed The Installer Could N [More]
I tried to discover 3550-Switche with our Cisco WLSE V2.5. Two 3550 devices working fine (V12.2.(8)EA1)+(V12.2.(9)EA1). Other 3550 devices with V12.2.(13)EA1 didn't respond. I don't know why. (same config) -I checked the SNMP-connection with the WLSE [More]
Hi friends, Is there any way or plugin available in eclipse 3.0 to list the uncommitted files (to cvs) . Thanks in advance.dangerous wrote: yeah you are right......... but it would be fine...... if there was an option which lists out all the uncommit [More]
Hi, Can metadata from 9i exported and imported to 10g? RegardsAs Oracle is strongly backward compalible - yes you can extract metadata from 9i and import it into 10g (I assume you are talking about your own objects metadata, like tables DDLs)Read oth [More]