Looking to filter data out of a pie chart.

[Analyst240]

Hello,

I am currently working on creating a pie chart.  To simplify things the pie chart has 4 parts. Lets call them 1,2,3,4.  1 and 2 are from category A. and 3,4 are from Category B. I want to filter out category A so that the pie chart will only show the percentages of 3,4 rather than all 4.  Essentially its like saying in a table show me all rows where Column 1 = A and not rows where Column 1 = B. But I want to do this in graph as the sheet loads and not have a user have to click on the tab to filter on their own.

The expression I am using now is as follows:     Count(IF (Name = 'A',Field,0))   

With this I am hoping to only have the graph do a count of the rows where the data matches what I want and for the data I don't want have it count as 0 so it wont show up.  This does not seem to make any difference when it updates.

I am happy to answer any further questions.

Thank you,

[Lisa_P]

Count({<Name = {A}>}Field)

[Analyst240]

I am seeing "The chart is not displayed because it contains only negative or zero values." I'm assuming this may be saying it filtered out all results?

[dwforest]

Count({<Name={'A'}>} Field)

Yes, the message indicates the filter yields no positive values.