RE: Excel 2007 Pivot Table - Problem with custom field?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi,

Maybe, add the Variance field to the Row Label area (as well as the Value
area) and filter on it there.

If this helps, please click the Yes button

Cheers,
Shane Devenshire

"michael.beckinsale" wrote:

Hi All,

I am trying to do what l think is pretty basic calculation & filter
exercise with a pivot table but l cant get it right.

The pivot table scenario is something like this:

Report Filter = Company
Row Labels = Reporting Officer, Reporting Category, Cost Centre
Column Labels = Sum Values
Sum Values = YTD Actuals, YTD Budget, YTD Variance (Non are
calculated, they all come from source data)

The above works fine as far as it goes but what l really want to do is
only show the records where the variance is + or - 100,000

I have tried adding calculated fields etc but just cant get the
desired result. Adding a column to the source data is not an option
because 'Account Code' is the next level down and sub totals would be
required in the source data. Additionally l would really like to avoid
a calculation outside the pivot table as a report has to be run for
several different company's.

Surely this can be achieved?

All help / ideas greatly appreciated

Regards

Michael


.

Relevant Pages

  • RE: Pivottable calculated item - how to suppress zero?
    ... layout - Choose PivotTable Tools, Design, Report Layout, Show in Tabular ... I can use a value filter to eliminate all rows in the ... pivot that have zero value. ... calculated item that sums a few of the "third row label" values. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: strange behaviour of ntp peerstats entries.
    ... variance truly does minimize the offset variance. ... the filter reduces the variance by some 10 ... delay variance IS reduced, ...
    (comp.protocols.time.ntp)
  • Re: Lowpass filtering for OFDM introduces interference?
    ... Evaluating this at some arbitrary k = k_0, this relationship is clearly not affected by the size of the DFT, nor by the amount of noise at any other k. ... variance of vshould be reduced leading to a reduced noise variance of ... Because each bin of the DFT is a matched correlation filter. ...
    (comp.dsp)
  • Re: variance
    ... if you want the local variance (as a function of position around ... % Demo to take the local mean, variance, and standard deviation ... title('Original Image', 'FontSize', fontSize); ... % Perform a variance filter. ...
    (comp.soft-sys.matlab)
  • RE: Pivottable calculated item - how to suppress zero?
    ... "Shane Devenshire" wrote: ... I can use a value filter to eliminate all rows in the ... pivot that have zero value. ... calculated item that sums a few of the "third row label" values. ...
    (microsoft.public.excel.worksheet.functions)