# Louise Stub Hansen

• Total activity 322
• Last activity
• Member since
• Following 0 users
• Followed by 0 users
• Votes 137
• Subscriptions 92

## Activity overview

Latest activity by Louise Stub Hansen
• Louise Stub Hansen commented,

Unfortunately I don't think its possible. But maybe I just don't know the trick yet. Hopefully someone else will answer your question too :)

• Louise Stub Hansen commented,

Is it not possible for you to arrange it in the order you need, when you define your crosstable:

• Louise Stub Hansen commented,

Hi Karoline I have made an example with 3 dimensions: Køn, År, Ansættelsesforhold Then I have made a calculated column. Antal = count(d1, all(c), m1) that counts all "children" ~ the number of "Ans...

• Louise Stub Hansen commented,

The only way I know of, is to create 6 new columns and transport the values in the order you need. But then you have to manually update with new columns, when a new year arise. Not the best solutio...

• Louise Stub Hansen commented,

Hi Marlene Just a quick suggestion: Maybe you could make a new column that counts 0, 1, 2, 0, 1, 2 etc. with syntax mod(xx,3). And then the syntax for column D could be: if the new coulmn = 0 then ...

• Louise Stub Hansen commented,

Hi Michael If it is a calculated column you need to refer to it as c1, c2, c3 etc. instead of m1, m2, m3. So the syntax might be: value > sum(c1,0,m1) If you click at "Advanced calculations": And ...

• Louise Stub Hansen commented,

I have asked this question as well: https://community.targit.com/hc/en-us/community/posts/360014706278-Repeat-dimension-members-in-export-to-excel?page=1#community_comment_360003824357 Unfortunatel...

• Louise Stub Hansen commented,

Hi Niels FYI I think we found the problem and a solution. It turned out that when I sent him a direct link to the analysis, he did not have any problems opening the hierarchi. The problem appeared ...

• Louise Stub Hansen commented,

I would like to know that as well. So far I've maintained a list manually - updating it manually every 6 month (to delete old cubes and data sources that is no longer in use). But it often takes me...

• Louise Stub Hansen commented,

Hej Flemming Er det ikke muligt at lave en ny beregnet kolonne, hvor du definerer et 1-tal, hvis procenten er > 0, og ellers 0. Og derefter kan du lave en beregnet række, der summer denne kolonne. ...