Page 2 of 2
Re: Changing Quick view depending on cell drop down
Posted: Thu Jun 18, 2020 12:02 pm
by kalyan846
concatenating if this is done i will be good to go, last step i think so
Re: Changing Quick view depending on cell drop down
Posted: Thu Jun 18, 2020 12:04 pm
by Wim Gielis
Is this the first time you use Excel ?
=TM1RPTVIEW("KT-FPA:}ElementAttributes_" & C14 & ":40173141",0,TM1RPTFMTRNG40173141,TM1RPTFMTIDCOL40173141)
Re: Changing Quick view depending on cell drop down
Posted: Thu Jun 18, 2020 12:12 pm
by kalyan846
No, but the elements are not changing dynamically when i select the dimension, i tried it
Re: Changing Quick view depending on cell drop down
Posted: Thu Jun 18, 2020 12:32 pm
by tomok
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.
Re: Changing Quick view depending on cell drop down
Posted: Thu Jun 18, 2020 12:44 pm
by lotsaram
You need to replace ALL the hardcoded references to the dimension with a reference to your dimension selection.