|
|
|
Rank: Advanced Member
Groups:
Joined: 4/8/2011
Posts: 41
|
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  Then Top20 And then I hide rows where Samlet Oms < 150000, but now I get only 12 rows. How do I solve this? Regards Lotte Best regards
Lotte Bjørn
www.danskespil.dk
|
|
|
Rank: Newbie Groups: Joined: 3/24/2011 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.
|
|
|
|
Rank: Newbie
Groups:
Joined: 5/18/2011
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é
|
|
|
|
Rank: Advanced Member
Groups:
Joined: 4/8/2011
Posts: 41
|
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
www.danskespil.dk
|
|
|
Rank: Newbie Groups: Joined: 3/24/2011 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?
|
|
|
|
Rank: Advanced Member
Groups:
Joined: 4/8/2011
Posts: 41
|
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
www.danskespil.dk
|
|
|
Rank: Advanced Member Groups: Joined: 1/13/2012 Posts: 33
|
Have you tried to change the toplist 20 from the "TB" measure to "Samlet Oms"?
|
|
|
Rank: Administration Groups: Joined: 4/7/2011 Posts: 111
|
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. The "Less than 1 mill flag" is a calculation that is defined as: if sum(d1, 0, m1) < 1000000 then 1 else 0In 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: 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. Ole Dyring
|
|
|
|
- Anonymous
|
