en
Welcome Guest! To enable all features please Login or Register.
Options
Go to last post Go to first unread
SO  
#1 Posted : Wednesday, October 21, 2015 8:51:39 AM(UTC)
SO
Rank: Advanced Member

Groups: extranet\Customer
Joined: 8/19/2014(UTC)
Posts: 72

I have crosstab with the standard grand totals at the top. Below I want to hide all members where the value in a certain column is < 0,05. If I add a visibility agent for the column and hide members where value < 0,05 my grand total also gets hidden if it less than 0,05.

How can I hide only the rows with visibility agent and keep my grand total?
Niels Thomsen  
#2 Posted : Wednesday, October 21, 2015 10:36:01 AM(UTC)
Niels Thomsen
Rank: Advanced Member

Groups: extranet\Customer
Joined: 4/5/2011(UTC)
Posts: 103

Hi!

I suggest that you add a little syntax to your visibility agent:

value < 0,05 and count(d1,all(c),m1)=0 (I'm guessing that your data is in the first column (d1).

count(d1,all(c),m1) means count the "children" of a certain cell.
A subtotal (or grandtotal) has a number of children, while a row with no levels below it has no children.

The visibility agent tests if the value is less than 0,05 and we are not at a total level.

Hope it makes sense.

Best Regards
Niels Thomsen

https://dk.linkedin.com/in/ncthomsen


SO  
#3 Posted : Wednesday, October 21, 2015 10:51:52 AM(UTC)
SO
Rank: Advanced Member

Groups: extranet\Customer
Joined: 8/19/2014(UTC)
Posts: 72

Originally Posted by: Niels Thomsen Go to Quoted Post
Hi!

I suggest that you add a little syntax to your visibility agent:

value < 0,05 and count(d1,all(c),m1)=0 (I'm guessing that your data is in the first column (d1).

count(d1,all(c),m1) means count the "children" of a certain cell.
A subtotal (or grandtotal) has a number of children, while a row with no levels below it has no children.

The visibility agent tests if the value is less than 0,05 and we are not at a total level.



Thanks, this work great! I changed from d1 to c3 since it's at my calculated column #3 the visibility agent is added.

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