Current Position:Home > Total in Pivot Table

Total in Pivot Table

Update:11-30Source: network consolidation
Advertisement
Hi,
I have built a pivot table where due to the large number of resort, I created an extra column and
put the following formula
CASE WHEN RCOUNT(1)<16 THEN '1-15' WHEN RCOUNT(1) <31 THEN '16-30' WHEN RCOUNT(1)<46 THEN '31-45' WHEN RCOUNT(1)<61 THEN '46-60' ELSE '61+' END
The table groups number of nights by certain channel (OWS, ADS, GDS) and sub- channel
Row 1-15
OWS WEB1 3
WEB2 5
TOTAL OWS *8*
GDS 1A 6
UA 3
TOTAL GDS *9*
Basically is calculating the total on each page, instead the total of all OWS from all the pages in the last page.
I tried to place the total on section, page, measure level etc.. but I do not get what I want.
Any idea?
Regards
Giuliano

The Best Answer

Advertisement
You have the "channel" column in the Rows section, yes? Then click on the "sigma sign" on the channels column. It will give you totals by channels which looks like what you want.
  • % of calculation in GRAND TOTAL in PIVOT TABLE Update: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

  • Remove the word "Total" in Row Totals in Pivot Tables Update:11-30

    Hi, Is it possible to remove the word "Total" that appears in Row Totals in Pivot Tables? Eg. If there are 2 Dimension Columns -- Year and Month .... and if we do row totals on Year The total appears as *'2008 Total'* or *'2009 Total'* etc. i.e.

  • Navigation of Grand total in pivot table Update:10-11

    I'm currently working in report development Oracle BI wherein I need to develop a report using pivot table. I need to do summation at both row and column level and when clicked on the Grand Total level it should display entire resultset. According to

  • Grand Total in Pivot Table Update:11-30

    Hi, I have a pivot table with several measures and grand totals. The problem is that there is one measure where the totals show up incorrectly. By incorrectly I mean that this shouldn't be sum of rows, but a different calculation and I haven't found

  • Totals in Pivot table Update:11-30

    I have this pivot table in OBI EE. It have the base amount per year and per month. With one total per year, with sumatory of Base amount. Moth      2001 2002 2003 1 Base 4.206.068,79 4.817.526,27 4.315.587,17 2 Base 4.100.429,84 4.031.267,42 4.950.02

  • Grand total in Pivot Tables with Paging Update:11-30

    I could help with this issue please when we apply paging PivotTables there a way to show Grand total all pages, and I've noticed that the Grand total vee only when the last page or show all results at once. For me it is important to see the Grand tot

  • Grand totals in Pivot table in OBIEE Update:11-30

    Hi, I have a pivot table in which i want both row and column level totals. when i say summation-->after for both row and column i can see the totals but the column level totals are showing results(the row level totals are correct.) Any idea what mist

  • Total in Pivot Table Update:11-30

    Hi, I have built a pivot table where due to the large number of resort, I created an extra column and put the following formula CASE WHEN RCOUNT(1)<16 THEN '1-15' WHEN RCOUNT(1) <31 THEN '16-30' WHEN RCOUNT(1)<46 THEN '31-45' WHEN RCOUNT(1)<61

  • Could I add Cumulative Totals in pivot table? Update:11-30

    for example 08-1-1 08-2-1 08-3-1 A 1 2 2 B 1 2 2 C 1 2 2 Total 3 6 6 CumuTotal 3 9 15I add a cummulative column in a table. In this column, I calculate the accumulated turnover for 2000 and 2001. But the function don't stop at the end of the year 200

  • Unable to do Grand Total in Pivot table view in OBIEE 11g Update:11-30

    Hello Experts, I am totaly new for OBIEE 11g I have created a report and wanted to do row wise total. Simple grand total in OBIEE 11.1.1.5 version. While doing the summation 'After'. I am getting a Window internet explorer Pop-up Saying the following