TM1 Forum

I was wondering if someone can help me solving the following issue:

1-I have a Active sheet in perspective; products are displayed on rows while Years are displayed on columns.
2018 2019 2020 2021 2022
Prod A $3 $2 $4 $2 $2
Prod B $2 $5 $2 $4
.......
Prod Z $13 $22 $34 $21 $2

2 - My goal is to write an MDX query that select product and year to get a final results like this when I select year 2020 and Prod B

2018 2019 2020 2021 2022

Prod B $2

3- The following MDX: {TM1DRILLDOWNMEMBER( {[Product].[" & C21 &"]}, ALL, RECURSIVE )} allows me to select a product however I have yet to figure out how to write an MDX that will select the Years as well.

Thanks

I guess this is just a DBRW then, isn’t it ?
In a Perspectives active form columns are not dynamic.

Anyway, consider:
"{[Years].[" & C20 &"]}"

assuming C20 holds the year selection.