I am struggling with row replicator hierarchy. I have reviewed the multilevel grouping and subtotaling tutorial, but am missing something as I can't get the grouping correct. In my attached file the Summary and first report tab give the correct data. The report tab marked 160 (2) is a duplicate of 160, but I have modified it striving to show the budget distribution across twelve periods for all unique combinations of dimensions. Since I have more than ten items that make up the unique combination, I am using the filter= formula which posses the challenge for my row replicator grouping since the filter matrix is vertical.
The attached reports include one is in Design mode, the other in Report mode with all columns and rows unhidden.
Budget Report by Dim and Dist vs 1 01 - Report Mode.xlsx
Budget Report by Dim and Dist vs 1 01 - Design Mode.xlsx
Appreciate any advise on how to set the grouping properly for the row replicator hierarchy to work correctly.
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi,
I'm not sure exactly what is happening for you, but the point of copying down the values like you are doing in columns H, M, O, etc. is that when you reference those values from other formulas you can use the values in the same row. So for example, your formula in W31 references a bunch of values in row 24 and it should reference those values in Row 31. You are doing this in a lot of places, so you may be able to fix your problems by just updating the cell references.
Another thing that won't work is putting NL(Rows) functions inside an Excel IF function, such as in O25. An NL(Rows) function will only expand if it is the first function in the cell. So basically your NL(Rows) in this case is equivalent to an NL(First) except that it performs worse because it fetches the entire data set, so you should change that.
Regards,
Hughes
Please sign in to leave a comment.