jlin | Answers

I would like to add that "Item Names" has its use; however the current implementation is very flawed, in that the generated items loses all grouping structure. I would propose that the Generate Items feature...

Sau, The image of your sample code - how are you getting Quantrix to display the formulas in this way (with dark background)? It's very nice on the eyes!

You have my vote, Sau. Although syntactically I think putting the variable definitions near the front of the formula (after any "In ... " statement, but before the item name whose value is being set)...

If I understand Tahir correctly, he believes it would be easier to maintain a model where a single one matrix presents differently (w/ rows & columns filtered depending on user role) versus creating...

If I understand correctly, Tahir may have in one matrix (or table view) some sensitive information that should only be shown depending on user role. He desires to use a filter expression that filters rows...

Thank you Mike. The extra explanation helps!

Is this what you want? A single formula will do it.

FYI if you have the need to do different offsets simultaneously, I would suggest calculating a single index value (that ignores all summary items). That way can support multiple, differently offset data...

I am in fact already using Item Generation extensively! I end up having an input matrix with category DepartmentsInput and DepartmentsInfo, use Generate Items to populate items for a second Category Departments...