en
Welcome Guest! To enable all features please Login or Register.
Options
Go to last post Go to first unread
Lotte Bjørn Jensen  
#1 Posted : Monday, January 23, 2012 11:52:00 AM(UTC)
Lotte Bjørn Jensen
Rank: Advanced Member

Groups: extranet\Forum
Joined: 4/8/2011(UTC)
Posts: 68

Hi

I have a problem showing top 20, when I at the same time have a visible-agent on another column.
Does anybody know how to solve this?

First all the rows
UserPostedImage

Then Top20
UserPostedImage

And then I hide rows where Samlet Oms < 150000, but now I get only 12 rows.
How do I solve this?

UserPostedImage

Regards
Lotte
Best regards

Lotte Bjørn
Kho Wei  
#2 Posted : Friday, January 27, 2012 4:38:51 AM(UTC)
Kho Wei
Rank: Newbie

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

Hi. For your case, instead of using "Hide Member" in the Visibility Agent, you can use "Hide Value".

For example, this is what I have do to simulate this:
1. Create a crosstable. Customer on rows. No of Sales and Contribution as measures.
2. Visibility Agent Hide Value < 1000 on No of Sales
3. Top 5 members on Contribution.
(If I used Hide Member on No of Sales, one customer will be hidden.)

Would this be acceptable? Below is a screenshot of the output. Notice that 1 customer will display a blank No of Sales, instead of being hidden.

UserPostedImage

Edited by user Monday, January 30, 2012 3:38:24 AM(UTC)  | Reason: Not specified

Pardun  
#3 Posted : Friday, January 27, 2012 10:15:15 AM(UTC)
Pardun
Rank: Newbie

Groups: extranet\Forum
Joined: 5/18/2011(UTC)
Posts: 1

Hello,

don't use the Top 20-Calculation.

I think, with the visibility agent (only), you can solve this problem.
Use the nr.-column to hide all rows with No. > 20. Use this as additional visibility agent.

Kind regards André
Lotte Bjørn Jensen  
#4 Posted : Friday, January 27, 2012 4:26:08 PM(UTC)
Lotte Bjørn Jensen
Rank: Advanced Member

Groups: extranet\Forum
Joined: 4/8/2011(UTC)
Posts: 68

Hi

I can't see the screenshot, but I'm not sure that it's solving the problem.

André, I've tried your solution, but I can't make it work.

Lotte :-)
Best regards

Lotte Bjørn
Kho Wei  
#5 Posted : Monday, January 30, 2012 3:40:09 AM(UTC)
Kho Wei
Rank: Newbie

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

Lotte, I've reloaded the image. Take a look.

My interpretation of the problem was as the following:
To have a Top N sort of dimension members based on measure A and at the same time, filter off values in the Intelligent Agent based on measure B without certain dimension members disappearing to keep the Top N.

If that understanding is not correct, perhaps you can provide additional description.
The other possible output that I can imagine is that you want to get a Top N sort of dimension members based on Measure A, from a set of dimension members filtered based on Measure B with value < X (Measure B). Is this what you're looking for?

Edited by user Monday, January 30, 2012 6:12:18 AM(UTC)  | Reason: Not specified

Lotte Bjørn Jensen  
#6 Posted : Monday, January 30, 2012 11:12:32 AM(UTC)
Lotte Bjørn Jensen
Rank: Advanced Member

Groups: extranet\Forum
Joined: 4/8/2011(UTC)
Posts: 68

No 2 is what I want. I want to hide members where measure < 150000, and still get top20, but when I hide the members I only get top12.

Lotte :-)
Best regards

Lotte Bjørn
Páll Bjarkason  
#7 Posted : Friday, February 17, 2012 10:41:23 AM(UTC)
Páll Bjarkason
Rank: Advanced Member

Groups: extranet\Forum
Joined: 1/13/2012(UTC)
Posts: 154

Have you tried to change the toplist 20 from the "TB" measure to "Samlet Oms"?
Best regards

Páll, CTS
Ole  
#8 Posted : Tuesday, April 10, 2012 1:41:00 PM(UTC)
Ole
Rank: Administration

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

Hi Lotte,

I believe I have found a solution to your challenge. Your problem and many crashed solution proposals are caused by an "invalid circular reference" that happens when you try to make a count based on something involving a visbility modifier while at the same time applying a visiblity agent to the object. The TARGIT client cannot handle both of these at the same time, and as such, the solution must eliminate one of them. My solution eliminates the visibility modifier on the calculation.

My example is based on the standard TARGIT demo data. At first I am creating a simple cross with two measueres, Revenue and Budget Variance %, per Salesperson. Then I sort data by the Budget Variance % column (right click column header and choose "Sort"). I have furthermore added two calculated columns which will be explained below the screenshot.

UserPostedImage

The "Less than 1 mill flag" is a calculation that is defined as:

if sum(d1, 0, m1) < 1000000 then 1 else 0

In other words, Salespersons are flagged as "1" if their revenue is less than one million.


The "Modified count" is defined as:

allcount(d1, d1:0, m1) - sum(c1, d1:0, m1)

In other words, it counts number of rows from the top, except the rows that have been flagged with the "Less than 1 mill flag".


Now I can add two visibilty agents, one on Revenue and one on Modified count, to hide Salesperson with Revenue less than 1 million and Salespersons with Modified count above 10:

UserPostedImage

I have also used the formatting option "Visibility" to hide the "Less than 1 mill flag" calculation.
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