Welcome Guest! To enable all features please Login or Register.
Go to last post Go to first unread
Tommy Jensen  
#1 Posted : Tuesday, December 20, 2011 9:02:43 AM(UTC)
Tommy Jensen
Rank: Newbie

Groups: extranet\Forum
Joined: 3/31/2011(UTC)
Posts: 1

I have created a crosstab with 2 nested dimensions (attribute hierarchies) on each axis.
On the x-axis i have placed "product group" on top and "year" underneath.
My global critera is set to 2011+2012.

I also have 2 nested dimensions on the y-axis. (names are not important)
I'm showing 3 measures for each column.

My problem is, that I don't have fact entries for both years for all my product groups, which means that for some columns (product groups) I only have the 2011 column underneath. This means that one of my measures (a calculated measure) for those columns are incorrect.

I would like to be able to determine whether I have 1 or 2 years (siblings) under each product group. My initial thougt was to insert a calculated measure (flag) to determine the number of siblings (years) under each product group and take this into consideration in my calculated measure.

Can anyone suggest a formula for such a calculated measure in a crosstab such as this one.
#2 Posted : Tuesday, December 20, 2011 9:26:58 AM(UTC)
Rank: Administration

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

Hi Tommy,

I have come up with something that is fairly simple, so I am afraid I am missing something. Anyway, have a look at the linked screenshot and let me know.


Best regards,

Edited by user Tuesday, December 20, 2011 3:04:24 PM(UTC)  | Reason: Not specified

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.