Re: Aggregate when measure contains a specific value

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

Would it be viable to create dimension on times retreaded? You can filter by
measure but it will be easier to do i you create a dim and then filter by
it. Not to mention what does it mean = 1? Does it aggregate on diff levles?


MC


"Owen J." <OwenJ@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:83731526-A244-46C1-BF5A-278337846895@xxxxxxxxxxxxxxxx
I have the following:

A hierarchy named [Tire].[Tire Hierarchy] that contains a list of tires by
tire manufacturer.

I have two measures in the fact table:
[Measures].[NRT Units]
[Measures].[Times Retreaded]

I need to create a sum of [NRT Units] for all tires at any level when the
[Times Retreaded] = 1. Anyone have any suggestions?


.

Relevant Pages

  • Re: Separating 1 workbook into multiple workbooks
    ... It will filter on column A this example ... I assume that your headers are in row 1 so the header "Supervisor" is in A1 ... Dim CalcMode As Long ... 'Name of the sheet with your data ...
    (microsoft.public.excel.misc)
  • Re: Separating 1 workbook into multiple workbooks
    ... It will filter on column A this example ... I assume that your headers are in row 1 so the header "Supervisor" is in A1 ... Dim CalcMode As Long ... 'Name of the sheet with your data ...
    (microsoft.public.excel.misc)
  • Re: Separating 1 workbook into multiple workbooks
    ... It will filter on column A this example ... I assume that your headers are in row 1 so the header "Supervisor" is in A1 ... Dim CalcMode As Long ... 'Name of the sheet with your data ...
    (microsoft.public.excel.misc)
  • RE: Set Filter from Startup form to another form
    ... Private Sub Form_Load ... Dim strPrg As String ... Private Function StartProgramAs String ... Now all that is necessary is to set the filter for each form where you want ...
    (microsoft.public.access.formscoding)
  • Re: Separating 1 workbook into multiple workbooks
    ... If you want we can make a macro to mail the 120 workbooks also. ... It will filter on column A this example ... Dim CalcMode As Long ... 'Name of the sheet with your data ...
    (microsoft.public.excel.misc)