Current Position:Home > pivot table limited to rows

pivot table limited to rows

  • % of calculation in GRAND TOTAL in PIVOT TABLE Updated:10-11

    Hi Gurus, I have a requirement to calculate the percentage based on the grand total in pivot table,but in row wise i am getting the percentage while in grand total level i am not getting correct values.I have tried with all the options like:average,S

  • How to make a layer from the ADF pivot table invisible , show-hide column-row-data Updated:10-11

    Hello all , I need to create a pivottable with ADF 12c for reporting purposes. I have a table or view with 10 items of type VARCHAR2 , C1,C2,C3,C4,C5,C6,C7,C8,C9,C10  and   10 items of type NUMBER N1,N2,N3,N4,N5,N6,N7,N8,N9,N10 The items of type VARC

  • Measures as Rows in Pivot Table? OBIEE 11g Updated:10-11

    Hi, Is it possible to show measures as rows and attributes as columns? I have only one value in my attribute columns. example: --------Company(Oracle)-----Country(India) Sales        100                  20000 Units         50                  40000T

  • Disabling auto sort of rows for Pivot Tables in BI Publisher Updated:10-11

    is there a way to avoid the Pivot table in BI Publisher from sorting your data and just display the rows in the order retured from the data model ? By default it is sorting the data in asc order. Thanks !hi jim if you carefully look inside the form f

  • How to Restrict the Rows In Pivot Table Updated:10-11

    Hi All, how to Restrict the Row in the Pivot table. My Requirement is like this. i have to show the top 10 values in the pivot table but My report is show all the values. how can we achieve this. any quick solution for this appreciated. Thanks, Yogi.

  • Percentage calculation in pivot table per row Updated:10-11

    Hello all, I do calculate two fields in a pivot table. First calculated field is the # of activities per user (standard SoD reporting field). Second calculated field is the # of activities per user with a certain classification (customized pick list

  • How to convert row data into columns without using pivot table? Updated:10-11

    Hello guys I have a report that has several columns about sales call type and call counts It looks like this: Calls Type Call Counts Missed 200 Handled 3000000 Rejected 40000 Dropped 50000 Now I wanna create a report that look like this: Missed call

  • Hide rows in Pivot table Calculated Items in OBIEE 11g Updated:10-11

    Hi All, I have requirement to show values in Pivot table such that values are divided into two sub totals and also shown in Grand Total. For Sub Total 1, all the rows can be shown with Sub total value. But for Sub Total 2, only Total value is to be s

  • Mimic "show data as percent of row parent" in non-pivot table Updated:10-11

    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

  • Pivot Table - Rows displayed Updated:11-30

    Hi, I have a pivot table report which display complete report instead of showing 25 rows first. Due to large number of rows we are getting Out of memory issue. Is it possible to display 25 rows first in Pivot table. Please help - as users are unable

  • Sorting Totals After on rows in a Pivot table Updated:11-30

    Hi, I need to Sorting Totals After on rows in a Pivot table . Can anyone help? ThanksTry this: 1) Duplicate your measure column in Criteria. 2) In the fx window, enter RANK(your_measure_column). 3) Place this column in the Rows section of your pivot

  • Row Based Calculations - Pivot Table Updated:11-30

    Hi, Can anyone help with creating calculating items in a pivot table. I have been following this example: I have created a calculation item on the column of my pivot table

  • Pivot Table Row and Column extension OBIEE 11g Updated:11-30

    Hi, I have pivot view report, I have 3 columns, 1) User Name 2) Date 3) Login Count User Name will be row(Vertical) Date will be Column heading (Horizontal) Login Count Measures So I will get login Count of user wrt date. Now When I give Wide range o

  • Need Pivot Table to hide only the rows in the table, now the entire sheet. Updated:11-30

    Hello, I have an basic pivot table (account type, account number, location, fees assessed) and wish to have a small summary table a couple of columns to the right of the data in the pivot table.   Is there a way to be able to have the pivot table onl