# John Jacobsen

• Total activity 22
• Last activity
• Member since
• Following 0 users
• Followed by 0 users
• Subscriptions 10

## Activity overview

Latest activity by John Jacobsen
• John Jacobsen commented,

Hi Niels The syntax in the calculated columns is like this: sum(d-1, 0, m4) sum(d-1, 0, m5) sum(d-1, 0, m6) etc. and avg(all, 0, m4) avg(all, 0, m5) avg(all, 0, m6) When I try to make further calcu...

• John Jacobsen commented,

Hi Flemming I'm fairly sure that you have to be in Designer mode to do that. I don't know if the version has anything to do with it. We have version 2021.0 build 19280 and it works perfectly.

• John Jacobsen commented,

Hi Flemming You can drag and drop the row with your calculation and place it in any row you like.

• John Jacobsen created a post,

### Sorting columns

Hi all, I need help with sorting in my Analysis where I have both measures from my dataset, calculated measures and caluculated columns. M1 = Helårs Person = Measure from datasetM2 = Disp. Beløb = ...

• 2 followers
• John Jacobsen commented,

Hi, Louise You understood it correctly. It works very nice. I had to make small changes to the syntax in order to get the result that I'm looking for. Thanks a lot for the help.

• John Jacobsen created a post,

### Custom Hierarchy with a Baseline

In my analysis, I work with both a baseline and an ongoing change between the most recent statement and the previous statement at any given time. It is relatively easy to calculate the ongoing chan...

• 2 followers
• 1 vote
• John Jacobsen created a post,

### Totals and Subtotals in calculated columns

Is there a workaround so that the totals and subtotals in calculated columns shows the sums of the column instead of the calculation of the individual row? As You can see in the example, the subtot...

• 3 followers
• 1 vote
• John Jacobsen commented,

Hi Ole, That helped, thanks. BR/ John

• John Jacobsen commented,

Hi Ole, Good idea, I will do that. But it seems that I don´t have access, I can´t get in. Best Regards, John

• John Jacobsen created a post,
Completed

### Global dimensions

It would be nice to have another interface in order to work with the global dimensions, kind of the way we work with Data Discovery in form of a sort of "drag and drop" way of connecting the differ...

• 3 followers