Re: Revenue and Gross Profit.

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

On 16 mar, 09:44, "miguel.salles" <miguel.sal...@xxxxxxxxx> wrote:
Hi,

We are using AS 2000, Excel XP.

We have a dimension called account, the highest level has 2 members,
Revenue and Expenses.

Our users want a report with 2 measures, one called Revenue Amount
(Sum of actual amount for the revenue group) and the second called
Groos Profit (Sum of Actual Amount for Reveneu - Expenses).

We are using unary operators, so if we use the measure Actual Amount
and filter reveneu I get the Revenue amount, If we do not filter
anything, the result is Gross Profit. Is there a way to show both
valeus on the same pivot table?

If not, how would I solve thsi matter?

Thanks a lot,

Miguel Salles
Bluston Educação e Tecnologia Ltda

Any one?

.

Relevant Pages

  • Re: Accural Revenue - How to divide revenue into Months
    ... work out how much of the revenue is earned in a particular month. ... earned for each day the project is in progress. ... the total revenue for each project divided out into each month depending on ... The answer below just gives the amount earned per day. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Which legilation?
    ... happens to match the amount that Defra cut from the amount that ... are referring to the DEFRA situation, which amounted to an app 12% cut - a ... HMRC are a totally different governent department, ... a great deal way less than 1% of their total 'revenue' - as I said mere ...
    (uk.rec.waterways)
  • Re: Accural Revenue - How to divide revenue into Months
    ... >The formula needs to look up when the project starts, ... of revenue is ... >The answer below just gives the amount earned per day. ... >amount in the correct column. ...
    (microsoft.public.excel.worksheet.functions)
  • Revenue and Gross Profit.
    ... Our users want a report with 2 measures, one called Revenue Amount ... Groos Profit (Sum of Actual Amount for Reveneu - Expenses). ... and filter reveneu I get the Revenue amount, ...
    (microsoft.public.sqlserver.olap)
  • text chnage event in asp .net datagrid
    ... amount for each category based on criteria selected by user. ... and amount are being populated from database in datagrid. ... of Revenue. ... I want to reflect change in Cost as 20 % of Revenue, ...
    (microsoft.public.dotnet.framework.aspnet)