Pivot Table Totals - Incorrect

[#1]

Hi

I have a problem with totals on a pivot table. The total should show 10,000 , but appears blank.   Below is a screen shot of the pivot table.

My formula is as follows for JHB - PO:

if([Component Code] = [ITEM CODE], sum(TOTAL([Loc Qty on PO])))

Under the total mode i've tried both Expression Total ans SUm, the result is still zero.

Your help would be appreciated.

kind regards

Nayan

[swuehl]

In your total line, the conditon [Component Code] = [ITEM CODE] is ambiguous, so QV can't evaluate to TRUE.

I am not really sure what you are trying to achieve, but maybe this works for you:

sum(TOTAL if([Component Code] = [ITEM CODE], [Loc Qty on PO]))

[#3]

Hi Swuehl

Thank you for replying.   Your formula did not work exactly.

The table above is part of a buying template (see below)

When we buy we look at the actual components sold  .

The totals figures you see are totals of FEEMS.  So when we buy, we look at the totals .  for JHB - PO , the total does not appear which makes it difficult (more awkward)  to work out stock required.

By the way:

• PO stands for Purchase Order
• The figures are all multiplied by component qty.  So for eg, Sales for FBCP12 in May-13 is actually 10. Therefore the sales of  component (FEEMS) is 20.

Hope this helps.

Your formula given did not work exactly.

kind regards

Nayan

[#4]

Hi Swuehl

Also, just to clarify, we only buy the FEEMS and the ITEM CODE's is out finished product that we build.

kind regards

Nayan

[#5]

Hi Swuehl

Any feedback on my last reply.

Kind regards

Nayan