en
Welcome Guest! To enable all features please Login or Register.
Options
Go to last post Go to first unread
Rasmus Remmer Nielsen  
#1 Posted : Thursday, June 27, 2013 11:49:04 AM(UTC)
Rasmus Remmer Nielsen
Rank: Advanced Member

Groups: extranet\Forum
Joined: 6/14/2011(UTC)
Posts: 22

Hi,

I have a measure that makes sense on leaf level only.

How do I create a visibility agent to hide it on non-leaf levels?

I would think to use the r0 definition, but am not quite able to make it work.

Original idea was to do something like this in the criteria box: "sum(0(r0),0(r0),0)=0" then hide.
Rasmus Remmer Nielsen  
#2 Posted : Thursday, June 27, 2013 12:56:56 PM(UTC)
Rasmus Remmer Nielsen
Rank: Advanced Member

Groups: extranet\Forum
Joined: 6/14/2011(UTC)
Posts: 22

Found a solution;

count(d1, all(c), m1) > 0

If the value has children the above will be > 0 and the measure value is hidden as per the rule.
Ole  
#3 Posted : Thursday, June 27, 2013 1:01:53 PM(UTC)
Ole
Rank: Administration

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

Hi Rasmus,

Actually, just hiding the subtotals and totals would do the trick.

If you want to see the subtotal and total members in your cross tab, but without values, you should make a "Hide value" visibility agent with a condition like this:

count(d1, all(c), m1) <> 0

Since only the non-leaf members are members with children, the above statement will hide values on non-leaf levels.

Best regards,
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
Ole  
#4 Posted : Thursday, June 27, 2013 1:03:49 PM(UTC)
Ole
Rank: Administration

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

Ok. :-) You found the solution yourself while I was posting the same thing. :-)
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
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