Several lines in table - Pie chart does not count the doubles

[Anonymous]

Hello community,

this is my data, 9 rows.

Name, Type, Category

A, S, Green

A, S, Blue

B, XXL, Green

C, S, Yellow

D, S, Red

D, S, Blue

E, M, White

F, S, Magenta

F, S, Blue

I want to display types in my pie chart. At the moment I get this numbers of types: 4xS and 1xM and 1xXXL.

My count is ignoring rows of a type in combination with the same name.

"A, S, Green" and "A, S, Blue" is counting for example only once instead of twice.

But I Want to get also the doubles. I want to get 7x S and 1xM and 1x XXL.

I am looking forward to your feedback. Thank you.

[amitchandak]

@Anonymous ,Not clear.

You can use Name as legend , Type as details and try

The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.

[Anonymous]

Thank you for your fast reply. Name as legend , Type as details is not working, the chart is white and blank. When I make an exampleFile it´s working fine. But not in my real data. I think about an error in my dataset. 

[amitchandak · Accepted solution]

@Anonymous , do you see any exclamation sign , near to visual? That may be cause of lot of data for visual. if so, Reduce some data and check