# Thomas Ejlerskov

• Total activity 17
• Last activity
• Member since
• Following 0 users
• Followed by 0 users
• Subscriptions 6

## 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...

• 2 followers
• 1 comment
• 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...

• 3 followers
• 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...

• 2 followers
• 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...

• 2 followers