Sitemap

Amicuk Programming Answers

Decimal Places in Pivot table

2015-10-11   Views:5

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, I have installed XE Oracle Database Version 9.0.1.4.0 in VISTA Home Premium and Oracle Developer suite10g version 9.0.4.0.19 I received the following error message when I try to connect the Database in Form Developer or sqlplusl. ORA-00604: error [More]
I have been working w/ a GLOBAL array defined in "session" The array is being populated with WORD objects when running a checks abbreviations script. Each word skipped are added using the push function. You can view and zero out the array, using [More]
Hi to all, I have to implement a form that is able to generate 3 or 4 or even more Excel files (depends which one the user has chosen)and I have some Problems, so I hope any one can help me here. 1. I want to start the reports sequential. I tried lik [More]
I Need to see the print view in numbers 3.0. No longer an option under "view" tab. Also the page view I'm given does not align with the preview page when actually go to print - they look different and neither has transfered my document the same [More]
Dear Friends,    Please send  me Extraction method(from r/3 to bw)in H.R MODULE    VERSION:BIW/BW 7.0  this is very urgent    Good reply will get good points   Regards,   SridharMendaHi Sridhar, Look at the help on BI Content in 2004s Human Resourses [More]
HI experts I am working additional fields in SQ02 . I added a new additional field for an info type in SQ02. Issue is when I right click on my additional field I can see options 'Only value' but for other fields I can see ' only value ' , 'only text' [More]
i need my pin number but don't remember what it is how can I figure this out?    josh0921, I know that being without your PIN can be quite the hassel. Just to be sure, are you referring to your billing account password or are you referring to a PIN u [More]
I've just rebooted, chose "choose library" and all the bloody thing is showing are the songs I've purchased from iTunes (about 50) and none of the thousands of songs from my cd rips!! How can I get my old library back?? Is there anyway to find i [More]
I am trying to migrate my illustrator plugin from CS 5 to CS 6. Removal of ADM has come as a big blow. I am trying to find alternatives for the UI. Flash/Flex is not a good solution (It works fairly well, but there are other issues around it - instal [More]
When I try to download Photoshop cc trail v. I get a promt says "This link needs to be opened with an application"   choose an application ? I don't understand this.... regards PoulYou can download Desktop app Free Creative Cloud | Download Adob [More]