Louise Stub Hansen
Activity overview
Latest activity by Louise Stub Hansen-
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. ...
-
Louise Stub Hansen commented, Hi Niels We have already used the look up function. This is the role: And this is lookup for the user who are missing the rights to open the hierarchi: thomru And this is lookup for our testuser:...
-
Louise Stub Hansen commented, We have asked for this possibility too for criterias. If I for example would like a criteria that automaticly select all categories that contain the text "Armani". But as far as I know this is not ...
-
Louise Stub Hansen commented, Hi Jesper Unfortunately I don't think you can use a formula with absolute references to count the "children" directly. I would suggest: Make a new calculation: Tæl = count(0,all(s),m1) And then us...