Originally Posted by: j.j.pedersen@secop.com 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