Thomas Ejlerskov
Activity overview
Latest activity by Thomas Ejlerskov-
Thomas Ejlerskov created a post, Grand total based on subset of rows
Hi Targit I have a simple crosstable with amounts per account per year (2020, 2021 and 2022). I want to create a seperate calculated column that gives me the grand total for 2020. Is it possible t...
-
Thomas Ejlerskov commented, Great tip - thanks Ole!
-
Thomas Ejlerskov created a post, Grand total column for waterfall charts
Hi Targit Is it possible to make a grand total column for waterfall charts in Targit? Below is an example of how it is done in Excel (10+20+30 = 80) I have been looking through the chart properti...
-
Thomas Ejlerskov commented, Hi again Niels You solution above is working, however not if you want to compare half a year against a full year. As you can see in my global criteria, i want to compare the full year average for 2...
-
Thomas Ejlerskov commented, Hi Niels Thank you for your solution - it works as intended given you have data for all months, but not if you have any "gaps" in the data :-) In my global date criteria, i have selected from Janu...
-
Thomas Ejlerskov created a post, Average calculation for children in hierarchy
I want to create a bar char showing average number of cases per month for each year. For example: 139 reported cases YTD Dec. 2020 = 139 / 12 = 11,58 average cases per month 94 reported cases YTD J...
-
Thomas Ejlerskov commented, Hi Ole. The solution above works perfectly - thank you. I have another example i hope you can help with :-) I have a crosstab where i have amounts per kg for each month in the period 2016-2021. I ...
-
Thomas Ejlerskov commented, Hi Niels This works perfectly :-) Thanks! /Thomas
-
Thomas Ejlerskov commented, Hi Ole. Is it possible to make a direct reference as well you if add another dimension to the crosstab that is not part of the existing hierarchy? For example customer - so the column order would b...
-
Thomas Ejlerskov created a post, Calculate deviation between two calculated row totals
I have a crosstab which shows actual and budgeted sales for top 10 customers. I have a calculated column ("deviation") which shows the difference between actual and budget figures in percent. At th...