Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 :
As a calculated dimension, while suppressing the null values.
Aggr(Only({1<Category={'X'}>} Itmes_Name ), Itmes_Name)
Thanks Dear u solve It
As a calculated dimension, while suppressing the null values.
Aggr(Only({1<Category={'X'}>} Itmes_Name ), Itmes_Name)
Thanks Dear u solve It