Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
C1 B1 0
Please advise what I want is the following result
Country Branch Expression
C1 B1 100
C1 B1 100
could you post small sample file?