Separate Pia Charts with two column

[MrJanjua]

I have two columns with Item_name and Category

Itmes_Name        Category

A                                   X

B                                   X                                  

A                                    X

B                                    X

V                                    Z

V                                    Z

I wants to make two pia chart with same table 1 is for X category and one is for Z category

I need Expression to select data from category X with Items :  

[BrunPierre · Accepted solution]

As a calculated dimension, while suppressing the null values.

 Aggr(Only({1<Category={'X'}>} Itmes_Name ), Itmes_Name)

[MrJanjua · Accepted solution]

Thanks Dear u solve It