Changing Quick view depending on cell drop down

kalyan846 · Post by **kalyan846** » Thu Jun 18, 2020 12:02 pm

concatenating if this is done i will be good to go, last step i think so

Wim Gielis · Post by **Wim Gielis** » Thu Jun 18, 2020 12:04 pm

Is this the first time you use Excel ?

=TM1RPTVIEW("KT-FPA:}ElementAttributes_" & C14 & ":40173141",0,TM1RPTFMTRNG40173141,TM1RPTFMTIDCOL40173141)

kalyan846 · Post by **kalyan846** » Thu Jun 18, 2020 12:12 pm

No, but the elements are not changing dynamically when i select the dimension, i tried it

tomok · Post by **tomok** » Thu Jun 18, 2020 12:32 pm

kalyan846 wrote: ↑Thu Jun 18, 2020 12:12 pm No, but the elements are not changing dynamically when i select the dimension, i tried it

That's probably because your TM1RPTROW formula in cell B17 is not set up properly to pull back all the elements in the dimension. I suggest making it MDX-based and have the MDX statement based on the dimension name in cell B14.

lotsaram · Post by **lotsaram** » Thu Jun 18, 2020 12:44 pm

You need to replace ALL the hardcoded references to the dimension with a reference to your dimension selection.

TM1 Forum

Changing Quick view depending on cell drop down

Re: Changing Quick view depending on cell drop down

Re: Changing Quick view depending on cell drop down

Re: Changing Quick view depending on cell drop down

Re: Changing Quick view depending on cell drop down

Re: Changing Quick view depending on cell drop down