en
Welcome Guest! To enable all features please Login or Register.
Options
Go to last post Go to first unread
Thomas  
#1 Posted : Friday, May 27, 2016 9:19:47 AM(UTC)
Thomas
Rank: Member

Groups: extranet\Forum
Joined: 5/19/2016(UTC)
Posts: 7

Hi everybody

I want to now if it is possible re re-arrange my calculations in a crosstab. Please see the example below:

UserPostedImage

I want to put my calculation (A+B) between column B and C. However, when i try do drag-and-drop the calculation, i am only able to position it at either the start or the end of the crostab.

Is it possible to position the calculation between my measures (colums)?

Edited by user Friday, May 27, 2016 9:22:34 AM(UTC)  | Reason: Not specified

Ole  
#2 Posted : Friday, May 27, 2016 10:14:22 AM(UTC)
Ole
Rank: Administration

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

Hmmm. It would work if A, B, C and D were standard dimension members. So I presume A, B, C and D are measures? If that is the case, you will need to copy C and D to two new calculated columns sum(d1, 0, m3) and sum(d1, 0, m4).

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
Thomas  
#3 Posted : Friday, May 27, 2016 11:21:00 AM(UTC)
Thomas
Rank: Member

Groups: extranet\Forum
Joined: 5/19/2016(UTC)
Posts: 7

That is correct, the colums are all measures, not dimensions.

The solution of copying the colums works though. I will try to see if your solutions works. Thanks.
Users browsing this topic
Anonymous
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.

Notification

Icon
Error