en
Welcome Guest! To enable all features please Login or Register.
Options
Go to last post Go to first unread
Jens J. Pedersen  
#1 Posted : Saturday, March 28, 2015 9:13:17 AM(UTC)
Jens J. Pedersen
Rank: Newbie

Groups: extranet\Forum
Joined: 10/19/2012(UTC)
Posts: 2

With a structure as this:

Dim A Dim B Period1 Period2
A X 12 4
A Y 2 6
A Z 6 8
B X 12
B Z 43 33
C X 22 23
C Z 9 15
Sum of X ? ? ?
Sum of Y ? ? ?
Sum of Z ? ? ?

I would like to calculate the totals of the Dim B level, but I didn¨t succeed, so I hope you can help.

Regards
Jens
Steffen Davidsen  
#2 Posted : Monday, March 30, 2015 7:52:54 AM(UTC)
Steffen Davidsen
Rank: Advanced Member

Groups: extranet\Forum
Joined: 7/8/2014(UTC)
Posts: 28

Originally Posted by: j.j.pedersen@secop.com Go to Quoted Post
With a structure as this:

Dim A Dim B Period1 Period2
A X 12 4
A Y 2 6
A Z 6 8
B X 12
B Z 43 33
C X 22 23
C Z 9 15
Sum of X ? ? ?
Sum of Y ? ? ?
Sum of Z ? ? ?

I would like to calculate the totals of the Dim B level, but I didn¨t succeed, so I hope you can help.

Regards
Jens


Good question.

It look as if TARGIT treats two row dimensions as a combined dimension. I was not able to refer directly to X in Dimension B by using the @"[dimension value]" command.

In that case my only suggestion would to use a function as:
sum(all,d1,m1)+sum(all,d4,m1)+sum(all,d6,m1),
if X in Dimension B is located in row 1, 4 and 6 (as shown in your example).

However, this only works if the structure of your table is completely independent of time, that is, if X in Dim B is always located in row 1, 4 and 6. There are some possible solutions to make sure that the row structure stays the same (for example by using a "show all dimension" measure and hide it in the visibility tab)

On the other hand - the Dim B totals are independent of A, so another solution might be to omit dim A in a new crosstable and calculate the totals there.

But wait and see. Ole or Pall might have some better ideas :-)

Best regards,
Steffen
Ole  
#3 Posted : Monday, March 30, 2015 8:48:52 AM(UTC)
Ole
Rank: Administration

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

Hi Jens,

There is rarely used feature within TARGIT called "Multidimensional subtotals" that might work for you when you have two or more dimensions on the vertical axis of your crosstab.

You apply it by right clicking your table, and from the menu choose "Table / Totals and subtotals / Multidimensional subtotal rows".

This should produce total rows for each of your XYZ dimension members.

You may even apply the "Column totals after members" to have these totals appear at the bottom of your table.

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
Steffen Davidsen  
#4 Posted : Monday, March 30, 2015 9:16:43 AM(UTC)
Steffen Davidsen
Rank: Advanced Member

Groups: extranet\Forum
Joined: 7/8/2014(UTC)
Posts: 28

Originally Posted by: od@targit.com Go to Quoted Post
Hi Jens,

There is rarely used feature within TARGIT called "Multidimensional subtotals" that might work for you when you have two or more dimensions on the vertical axis of your crosstab.

You apply it by right clicking your table, and from the menu choose "Table / Totals and subtotals / Multidimensional subtotal rows".

This should produce total rows for each of your XYZ dimension members.

You may even apply the "Column totals after members" to have these totals appear at the bottom of your table.

BR / Ole



.. I should have waited for Ole's reply. Nice and easy feature :-)
Jens J. Pedersen  
#5 Posted : Friday, April 3, 2015 8:09:31 AM(UTC)
Jens J. Pedersen
Rank: Newbie

Groups: extranet\Forum
Joined: 10/19/2012(UTC)
Posts: 2

Hi Ole,

simple and works perfect - the sums show at the top as needed.

...and thank you to Steffen for trying...

br
Jens
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