software

Help, I'm going nuts.

I have a challenge that is so far beating me. I have a pivot table that
summarises sales values and margins by month and I had no problem in adding a
calculated field with a monthly budget figure and charted this quite easily.

So far so good. However, I now need to break these numbers down by product
groups, but I can't get the calculated budget field to break down by product
group - I have tried using an IF statement in the calculated field but it
just returns the ‘false’ value (i.e. if, true, false). Also the total isn’t
adding up, e.g. the budget part of the table resembles:

Monthgroup agroup btotal
Jan100100100
Feb etc.

The chart has gone from clear and simple to a techicolour nightmare – but
I’ll worry about that when I have got the pivot table sorted.

Any help is much appreciated.

Regards,

NigelPut you IF statement in your source data e.g. create new fields in you data
source, update your pivot table data source range and then drop them into the
pivot table.

Hope that helps.

regards
KM

quot;Nigel Drinkwaterquot; wrote:

gt; Help, I'm going nuts.
gt;
gt; I have a challenge that is so far beating me. I have a pivot table that
gt; summarises sales values and margins by month and I had no problem in adding a
gt; calculated field with a monthly budget figure and charted this quite easily.
gt;
gt; So far so good. However, I now need to break these numbers down by product
gt; groups, but I can't get the calculated budget field to break down by product
gt; group - I have tried using an IF statement in the calculated field but it
gt; just returns the ‘false’ value (i.e. if, true, false). Also the total isn’t
gt; adding up, e.g. the budget part of the table resembles:
gt;
gt; Monthgroup agroup btotal
gt; Jan100100100
gt; Feb etc.
gt;
gt; The chart has gone from clear and simple to a techicolour nightmare – but
gt; I’ll worry about that when I have got the pivot table sorted.
gt;
gt; Any help is much appreciated.
gt;
gt; Regards,
gt;
gt; Nigel
gt;