en
Welcome Guest! To enable all features please Login or Register.
Options
Go to last post Go to first unread
Eric Maibach  
#1 Posted : Friday, November 30, 2012 5:53:12 PM(UTC)
Eric Maibach
Rank: Advanced Member

Groups: Administrators
Joined: 11/28/2012(UTC)
Posts: 12

I am trying to create a new Analysis, and in the end I would like it to look something like this:

UserPostedImage

I am having trouble with the percentage column. I have reviewed the Advanced Calculations book from the Targit class that I went to and I have been able to figure out how to do a percentage as a grand total, and as a measure. However I have not been able to figure out how to add it as a subtotal. Is this possible?

Thank You,

Eric
Páll Bjarkason  
#2 Posted : Monday, December 3, 2012 8:25:34 AM(UTC)
Páll Bjarkason
Rank: Advanced Member

Groups: Administrators
Joined: 1/13/2012(UTC)
Posts: 154

Hi Eric

Have you tryed this?

Custom calculation - As a new measure
Conventional:
sum(all(s), 0, m1)

Conventional / (Conventional + Pasture)
sum(all(s), 0, m1) % sum(all, 0, m1)

UserPostedImage
Visibility is used to hide unwanted totals and calculated measures.

Edited by user Tuesday, May 28, 2013 11:57:29 PM(UTC)  | Reason: pic

Best regards

Páll, CTS
Eric Maibach  
#3 Posted : Monday, December 3, 2012 3:41:46 PM(UTC)
Eric Maibach
Rank: Advanced Member

Groups: Administrators
Joined: 11/28/2012(UTC)
Posts: 12

Thank you for you quick reply. I have been trying to use a measure calculation this morning, however I am having a couple of issues with it. In your example the totals for the Casual Clothing Retail company appear under the 'Underwear' group and I think this will be confusing for our users. I would instead like the totals to appear as a subtotal, like this:

UserPostedImage

As you can see the percentage in the subtotal is always 100%, so I am getting something wrong in my calculation. The calculation I am using is:

sum(all(c), 0, m1) / sum(all, 0, m1)

The other trouble I am having with using a measure calculation is I cannot figure out how to only show it as a subtotal. I can figure out how to use the visibility agent to hide the field based on the value, but I have not been able to figure out how to hide the field based on what level it is at.

Thank You,

Eric
Páll Bjarkason  
#4 Posted : Tuesday, December 4, 2012 12:07:26 PM(UTC)
Páll Bjarkason
Rank: Advanced Member

Groups: Administrators
Joined: 1/13/2012(UTC)
Posts: 154

Hej Eric

Have you tried to only show your numerator:(sum(all(c),0,m1)) to check your %-calculation? It always returns 0. This is why your fraction also always returns 0.

I think that you are trying to be over sophisticated in solving this problem. There is no need for a (c) modifier on the column parameter in the example you posted. Try this instead:
sum(0, 0, m1) / sum(all, 0, m1)

The column parameter highlighted in bold states that the numerator should be this column.

Edited by user Tuesday, May 28, 2013 11:57:40 PM(UTC)  | Reason: (c) og ikke copyright tegn

Best regards

Páll, CTS
Eric Maibach  
#5 Posted : Thursday, December 6, 2012 1:28:20 PM(UTC)
Eric Maibach
Rank: Advanced Member

Groups: Administrators
Joined: 11/28/2012(UTC)
Posts: 12

That fixed the calculation, thank you very much.

The last thing I am struggling with is how to only show the calculation at the subtotal level. For example, in the picture below I want to hide all of instances of the calculation that have a red box around them. So far I have not been able to figure out how to do this, is there a way?

UserPostedImage

Thank You,

Eric Maibach
Páll Bjarkason  
#6 Posted : Thursday, December 6, 2012 6:38:08 PM(UTC)
Páll Bjarkason
Rank: Advanced Member

Groups: Administrators
Joined: 1/13/2012(UTC)
Posts: 154

It is possible to hide a range of % on the Format visibility tab.
In the properties you can change "Select level". And choose the levels on the far left side of the picture.

UserPostedImage

Edited by user Tuesday, May 28, 2013 11:57:49 PM(UTC)  | Reason: Not specified

Best regards

Páll, CTS
Eric Maibach  
#7 Posted : Friday, December 7, 2012 1:31:49 PM(UTC)
Eric Maibach
Rank: Advanced Member

Groups: Administrators
Joined: 11/28/2012(UTC)
Posts: 12

Worked great, thank you!
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