Pivot Table Set Analysis not ignoring dimension

[#1]

I have a Pivot Table with "Detailed Industry" and "Band" are Dimensions.

Two Expressions:

• One gives me # of Claims by Detailed Industry AND Band This works:

=(sum([Claim Count]))

• Another Gives me # of Claims By Detailed Industry only (ignoring the band) This gives me the SAME number as above, like the set analysis is being ignored

=(sum({<Band =>}[Claim Count]))

What am I missing?!

[Anonymous · Accepted solution]

Hello.

If you make a selection on a Band, you will see the expressions giving diferent values: some will be zero. Set analysis will ignore the selection but not the chart dimensions. Maybe what you want for the second expression is this:

Sum(Total<[Claim Count]> [Claim Count])

This expression will ignore all chart dimensions EXCEPT [Claim Count].

Hope it helps.

[#3]

That's it, although I need the Claim Count BY Detailed Industry so I did this and it seems to work:

=Sum(Total<[Claim Count],[Detailed Industry]> [Claim Count])

[Anonymous]

Sorry, I pasted the wrong field name. I realy meant [Detailed Industry]. The correct expression is:

Sum(Total<[Detailed Industry]> [Claim Count])

There is no need to use [Claim Count] as a modifier for the Total qualifier.