How to create Funnel chart with count based upon filtered values

[rlongden]

My data resembles this:

Name	Count	Type
AAA	5	A
BBB	10	A
CCC	15	B
DDD	20	B

I want to create a funnel chart that shows:

1. Total Count = 50
2. Count of Type A = 15
3. Count of Type B = 35

The key point is both #2 and #3 are based upon SUM of the Count column AND where Type = [something].

Is this doable?

[parry2k]

@rlongden not sure if this is what you are looking for?

[rlongden]

A chart like that would be good, yes. Can you tell me how to create it based on the example table I provided?

[parry2k · Accepted solution]

@rlongden choose the funnel visual and add Type and Count column as shown below

[rlongden]

Thanks for the help. This gets me past the initial challenge. I'll need to fiddle with this to see if I can expand it to cover some other scenarios.