Niels Thomsen
Articles
-
Total visible values, each row (as a column)
Type: Inserted as a columnDescription: Calculates the sum of all visible values in each row.Range:Columns: All columns (visible)Rows: Each rowMeasures: First measureSyntax:sum(all(v), 0, m1)Sample ...
-
Total each row (as a column)
Type: Inserted as a columnDescription: Calculates the sum of all values in each row.Range:Columns: All columnsRows: Each rowMeasures: First measureSyntax:sum(all, 0, m1)Sample crosstab: ExampleCurr...
-
Total hidden values, each column (as a row)
Type: Inserted as a rowDescription: For each column and each measure, it will calculate the sum of all hidden rows.Range:Columns: Each columnRows: All rows (hidden)Measures: Each measureSyntax:sum(...
-
Total visible values, each column (as a row)
Type: Inserted as a rowDescription: For each column and each measure, it will calculate the sum of all visible rows.Range:Columns: Each columnRows: All rows (visible)Measures: Each measureSyntax:su...
-
Total each column (as a row)
Type: Inserted as a rowDescription: Calculates the sum of all values in each column, for each measure.Range:Columns: Each columnRows: All rowsMeasures: Each measureSyntax:sum(0, all, 0)Sample cross...
-
Extra linespace in crosstab
Looking at a hierarchy can often be a bit challenging - it can be a little hard to identify where a new group begins and another group ends.Here's a simple example of a crosstab showing hierarchica...
-
Update/Refresh connections when these have been changed by 3rd party tool
NOTE: The below is not recommended since all updates of settings, connections, etc. should always be conducted from within the TARGIT software. However, If an external program wants to modify a dat...
-
Other resources available on Filter Delegate
You can learn more about filter delegate in this webinar: TARGIT Webinar: Tips & Tricks: Filter Delegates Edition This blog-post also explains about the usage: Feature Showcase: Uncover Powerful...
-
Filter Delegate Advanced - Improve your datamodel
If you're not familiar with the basics of filter delegate, please refer to this article before continuing reading. Any datamodel of a certain size holds some dimensions and measures that are not di...
-
Filter Delegate Advanced - Filter across different data sources
If you're not familiar with the basics of filter delegate, please refer to this article before continuing reading. Filter Delegate alone is a strong feature - but combined with Mash-up dimensions i...