pivot table customization

ali_hijazi — Wed, 29 Aug 2012 09:17:31 GMT

Hello I got a pivot table with 2 dimensions

Country and Branch

and an expression that calculates the total number of shops

Now the Branch has to show only branches whose type is OFFICE

however the expression should show the number of shops of the branches that are not of type OFFICE totalled by Country

FOR EXAMPLE:

Country Branch Expression

C1 B1 100

C2 B2 50

......

this is fine if I don't put a condition on the branch to show only OFFICE branches

if I put the condition then I would get the following result

Country Branch Expression

C1 B1 0

Please advise what I want is the following result

Country Branch Expression

C1 B1 100

Re: pivot table customization

Wed, 29 Aug 2012 10:21:39 GMT

could you post small sample file?