Home > Default > How to not show detail but keep aggregated calculation results.

How to not show detail but keep aggregated calculation results.

November 30Hits:0
Advertisement
Hi,
I have some calculations performed through variables. For some reason, to keep the correct calculation displayed i can only do it by displaying the detail data I'm doing the calculations with. Is there anyway around this? I've attached an attachment giving a little more explanation of what i have and what i need .
thanks
any help would be appreciated

Answers

Hi,
Please follow below steps and let me know how it works
1. Right click on Centre column Init ID Rpt> hide > hide dimension (if you are not able to hide then make the column as small as possible).
2. Copy the formula of the left most in to the footer, so that the footer in the last row will also show BaseL
3. Now modify the formula of the cell containing 2.8 as = Nofilter(whtever it used to be there earlier)
4. Now apply filter and on the Basel column and give some value which cannot be true like 9999999 etc.,
5. Now Right click your table and uncheck the property Display table header.
6. You will have BaseL and 2.8 as per your requirement
Thanks,
Tanveer.

Read other 5 answers

Tags:

Related Articles

  • How to not show detail but keep aggregated calculation results.November 30

    Hi, I have some calculations performed through variables. For some reason, to keep the correct calculation displayed i can only do it by displaying the detail data I'm doing the calculations with. Is there anyway around this? I've attached an attachm

  • What is detailed report and aggregated reportNovember 30

    Hi gurus, We generally tell cube gives the aggregated report and ODS gives detail report could any body tell me what exactly meaning behind there Please give me a good example for make me good under stand.. Thanks in the advance Kiran Edited by: kira

  • How to display the detailed navigation with the Search ResultsNovember 30

    Hello Gurus, I was able to display the search results in the same frame rather than opening the new window and getting it displayed. Now when the search results are displayed, my detailed navigation and portal favorites etc.. all the iviews are autom

  • Entering details screen when only one result is foundNovember 30

    Dear Forum, I have a an application where one of the requirements is this: Is there a way to accomplish that when you search for a record on the masterscreen and only one result is found, the details are showed right away? Your help is much appreciat

  • Regrouping detail information to get summary resultNovember 30

    Hi gurus, I'd like to know if and how the following can be achieve. I have a data template that generates details information for a project. I use this information on the detail template but now I wan't to create a summary section that would use the

  • Details about net price calculationNovember 30

    Hi, I have to do a report where when the user clicks on the net prices, a new window raises with details about it like prices, discounts, charges, tax, totals, etc. But I don't know where I could find these items, actually even I don't know how the n

  • Excise Details need to be calculated in  FIFO basisNovember 30

    In my excise details in sales order or invoice should get copied as FIFO basis .Is this possible. If So from where I have to copy and what kind of standard Requirement are available in SAP for all the 3 ED condition types. Please help its argent. Tha

  • Aggregation of results based on rowsNovember 30

    Hi All, We are on BI 7 and are seeing the following issue on one of our queries. In the rows, we have gl account and fiscal period. The column is a restricted key figure which has an amount and is restricted on a fiscal year period range (01/2008 - 0

  • Detailed Log of Deleted Payroll Results.November 30

    I have deleted payroll results for an employee. This result had retro entries. Now I have no clue what was the Earliest MD Change date. Is there any way i can get this date??? Transaction SLG1 gives me the log but it does not say what all were the re

  • IR: aggregation result in report footerOctober 11

    Hello! This quote from "Beginning Oracle Application Express 4.2" at page 174 (about aggregation in IR): "The results are displayed at the end of the report." There is a simple method to print the results of aggregation to the report f

Copyright (C) 2019 wisumpire.com, All Rights Reserved. webmaster#wisumpire.com 14 q. 0.952 s.