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: 323

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
I work as an employee with TARGIT A/S. Any statement made by me in this forum represents my own opinion and state of mind, and is not necessarily related to or representative of TARGIT A/S.

UserPostedImage 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.