en
Welcome Guest! To enable all features please Login or Register.
Options
Go to last post Go to first unread
Steffen Davidsen  
#1 Posted : Tuesday, May 12, 2015 9:12:37 AM(UTC)
Steffen Davidsen
Rank: Advanced Member

Groups: extranet\Forum
Joined: 7/8/2014(UTC)
Posts: 28

Hello!

I have a question. A couple of months back, Ole taught me how to create an "Other" dimension containing all dimension values besides top3, using the visibility agent and calculations.

I have done so in the example below. The row "Other" is a calculation of all the hidden values in the specific column. The dimension values are hidden with a allcount>3 condition after making a descending sort order on Total wage. (see Ole's post here)

However, the crosstable seems to ignore all my instructions to put a "%" on the Percentage value at m3 under "Other". When I format the number of the Percentage measure, it ignores the dimension value "Other" (see below)

Does anyone know how to add this "%" to the member?

UserPostedImage

Best regards,

Steffen D. Davidsen
Skanderborg Kommune

Linkedin: Link
Páll Bjarkason  
#2 Posted : Tuesday, May 12, 2015 11:21:58 AM(UTC)
Páll Bjarkason
Rank: Advanced Member

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

Hi Steffen

The trick is to use a smart calculations feature called “Calculate in intersection”.
Check this post out http://www.targit.com/en...posts&t=487#post1350
Note to choose the correct calculation to “Calculate in intersection”

UserPostedImage

Edited by user Tuesday, May 12, 2015 11:25:22 AM(UTC)  | Reason: Not specified

Best regards

Páll, CTS
Steffen Davidsen  
#3 Posted : Tuesday, May 12, 2015 12:19:08 PM(UTC)
Steffen Davidsen
Rank: Advanced Member

Groups: extranet\Forum
Joined: 7/8/2014(UTC)
Posts: 28

Originally Posted by: Pá Go to Quoted Post
Hi Steffen

The trick is to use a smart calculations feature called “Calculate in intersection”.
Check this post out http://www.targit.com/en...posts&t=487#post1350
Note to choose the correct calculation to “Calculate in intersection”

UserPostedImage


What should I do without you? It worked perfectly! I appreciate it, thank you Páll!
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