Active Form Filtering month range

[maps]

hello everyone,

I got a problem implementing a Excel active form. Lets assume I need the data in the following format in an Active form.

Title: Year: 2011
Sales
rows: Member, Project, Month

The active Form should look like this.

Title: Year: 2011

Paul, Project XY, jan, 1000
Paul, Project Z, dec, 2000
John, Project XY sept, 500

I've already implemented the sheet as a active Form this is straight forward.

But now I want to be able to select a month range so that the data will only be shown for the moth range (example sept to dec). The structure needs to stay like explained before.

Paul, Project Z, dec, 2000
John, Project XY sept, 500

I had two ideas to solve that.

1.) Use an MDX Statement for the TM1RPTROW(-function.
MDX: {[Month].[april]:[Month].[dec]}

=TM1RPTROW($B$9;"blabla:Month";"";;"";1;"{[Month].[01]:[Month].[05]}";0; 0)

TM1RptRow(ReportView, Dimension, Subset, SubsetElements, Alias, ExpandAbove,MDXStatement, Indentations, ConsolidationDrilling)

pushing F9 after inserting the statement doesn't change anything in my active form. Another interesting thing is, that when I'm deleting the tm1rptrow statement and the data underneath pushing f9 it still loads the data (I'm using 9.4.1, excel 2003)


2.) Change the SusetsElements-Parameter of the TM1RPTROW( function of months.

'{AR}01'!$D$17:$D$28;

The Cells from D17 to D28 represent the 12 Months... I can access the elements via "= '{AR}01'!$D$xx". To test it I changed the range to $D$17:$D$19 (jan to march). Pushed F9 but nothing happened. The list is still the same was not updated.

To change the range doesn't have an impact of the data...

[csjean]

Hi maps,

Intead of F9

try ALT-F9 wich is what you should do to reload data in an active form.

Please see http://publib.boulder.ibm.com/infocente ... orm_N800F0

Hope this helps.