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
I was trying to figure out why there was a cricle with a lock image in it on the top of my phone , so i was going through settings and couldnt find anything that was out of ordinary .so then i was trying to make room for a software update.The only th [More]
Hi everyone, I just downloaded the trial of i-Work but I'm in trouble with Pages. Indeed I would like to see my white document, on which I'm writting, in the middle of my page. At the moment it is on the left, with grey on the right. And : 1- I don't [More]
I use C Cleaner to clean my CDrive. When opened it says "You must close Firefox/Mozilla to proceed with cleaning ". I don't know how to close it since I don't have it open right now.Hello Gary. What exactly are you downloading?Read other 2 answe [More]
Hi Guys, In our project we are planning to integrate OAAM11GR2 with OIM11GR2 and OAM11GR2 through Advanced integration. We have a requirement to call a third party authentication service from OAAM as a step up authentication for a particular user bas [More]
Moderator message - Please respect the 2,500 character maximum when posting. Post only the relevant portions of code Nothing remains, so locked. Rob Edited by: Rob Burbank on Mar 12, 2010 10:56 AMplease pass teh specified portion of the code explaini [More]
Hi, One of our customers is facing an error while executing a PL/SQL block like, declare l_flag varchar2(30); begin select max('Y') into l_flag from v$database; -- Can use any table here end; however, when the select query is changed to as follows, n [More]
Hi, I have a little problem concerning the Prototype file created by pkgproto. On my systems the /usr/local can be 3 different thing : /usr/local = symbolic links to /opt/local /usr/local = symbolic links to /export/opt /usr/local = directory /usr/lo [More]
Hello, We are installing XI 7.0 on a server with AMD64 processor architecture. OS is Windows 2003 server. For XI, JDK 1.4.2 is required. However, it appears that JDK for AMD64 is only available from version 1.5.0. Does anyone have a solution to this? [More]
Sometime in the last few weeks something strange has happened to my operating system: the default font in some dialog boxes (not all) and on many web pages as displayed by Safari (v4.0.4) and/or Camino (2.0.1) is American Typewriter Condensed. Conver [More]
I want to know if mac aitr or mac pro is ok for my needs I wil used mainly for photoshop and final cut Regards LuisThat depends on what size SSD you get and how many programs and files you store on the internal drive. Both PS and FC don't take up tha [More]