Welcome Guest! To enable all features please Login or Register.
Go to last post Go to first unread
Nick Bittcher  
#1 Posted : Wednesday, June 3, 2015 3:58:23 PM(UTC)
Nick Bittcher
Rank: Newbie

Groups: extranet\Forum
Joined: 6/3/2015(UTC)
Posts: 2


i have created a crossab with two comparisons, one measure and one dimension.

What i like to add is a calculation that is connected to the comparions.
From the manual i got the information, that you can refer to the name of a dimension by using sum(@"[....]",0,m1) for example.

My problem now is, that i used two comparisons. Is it possible to refer to the different steps of my comparisons.

To show what i like to do, some screenshots:


Edited by user Wednesday, June 3, 2015 3:59:09 PM(UTC)  | Reason: Not specified

#2 Posted : Wednesday, June 3, 2015 8:04:13 PM(UTC)
Rank: Administration

Groups: extranet\Forum
Joined: 4/7/2011(UTC)
Posts: 514

Hi Nick,

What you created in your crosstab is what I would call a Custom Hierarchy, or a client based hierarchy, with two dimensions (or comparisons) on the same axis.

The syntax you tried will only work on a "real" hierarchy, i.e. a hierarchy structure that has been defined on the database.

What you need is a little different syntax: sum(@"[Group 1]";"[Jan]", 0, m1)

A previous post touched on the same topic: http://www.targit.com/en...=posts&t=177#post365

BR / Ole
Ole Dyring
Users browsing this topic
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.



We use cookies to improve your site experience, but they also provide us with information on your use of our website.
To find out more about the cookies we use and how to delete them, see our Privacy Policy. By continuing to browse the site, you are consenting to our use of cookies.