Thomas Ejlerskov
Posts
-
Calculation: How to get value from first user dimension member
I have a simple crosstab with one dimension ("ItemGroup") and one measure ("Value"). In the crosstab i have added a user dimension ("Period") which has five members). How do i make a calculated co...
-
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...
-
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...
-
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...
-
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...