software

It seems that Excel calculates all possible permutations or a calcuation.
For example:

Region Person Budget Actual Variance (calculated)
North John 10 5 -5
North Peter 10 6 -4
East Mary 15 16 1
East Sue 15 14 -1

In the Excel pivot table, there are entries for Mary amp; Sue in the North
(even though there is no such data). The calculations are blank, but the
worksheet quickly becomes confusing. Is there a way to filter out these
quot;nonsensequot; permutations?

You can manually hide the rows, but there's no built in way to supress them.

Craig wrote:
gt; It seems that Excel calculates all possible permutations or a calcuation.
gt; For example:
gt;
gt; Region Person Budget Actual Variance (calculated)
gt; North John 10 5 -5
gt; North Peter 10 6 -4
gt; East Mary 15 16 1
gt; East Sue 15 14 -1
gt;
gt; In the Excel pivot table, there are entries for Mary amp; Sue in the North
gt; (even though there is no such data). The calculations are blank, but the
gt; worksheet quickly becomes confusing. Is there a way to filter out these
gt; quot;nonsensequot; permutations?--
Debra Dalgleish
Excel FAQ, Tips amp; Book List
www.contextures.com/tiptech.html