Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a Pivot Table with "Detailed Industry" and "Band" are Dimensions.
Two Expressions:
=(sum([Claim Count]))
=(sum({<Band =>}[Claim Count]))
What am I missing?!
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.
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.
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])
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.