Pivot table with a filtered dimension

[LuisGramillo]

Hi everyone, I need to create a table with different measures as columns, having a "pivot table" structure. The rows of the table will consider a specific set analysis that restricts each measure.

¿How can I create it? I added an example of the table conditions.

Thank you for your time

[robert_mika]

Could you provide more details?

Are you looking fr this kind of a pick/match solution?

[Amit_Prajapati]

Please clarify what exactly you want to display.

To create a pivot table, we need at least one dimension, one column, and one measure.

If you're trying to show product-wise amounts using the pick-match or set expression you mentioned, you can apply it directly or use it after creating master measures.