Pivot table with calculated dimension

[KarlaDS]

Hi everyone

I have a problem...i have this information:

And i want to use a pivote table to show the categories that contain a Description with "Undefined" value. But i also need to show the rest of the descriptions, not only "Undefined". I only can get this:

But I need to get this:

This is the data:

LOAD * inline [
Category,Description,Date
A,Undefined,01-01-2020
B,Juice,01-05-2020
B,Juice,01-07-2020
C,Butter,01-08-2020
A,Grapes,03-05-2020
A,Grapes,06-05-2020
C,Undefined,06-05-2020
C,Butter,03-03-2020
];

I hope someone can help me to figure out this problem.

Thanks!

[lironbaram]

hi 

using category as first dimension and description as second dimension 

use this expression in the pivot table 

Count({<Category=p({1<Description={"Undefined"}>}Category)>} Date)

[KarlaDS]

This is not working, with your code i'm getting this:

And this is the result that i need: