en
Welcome Guest! To enable all features please Login or Register.
Options
Go to last post Go to first unread
Páll Bjarkason  
#1 Posted : Thursday, February 16, 2012 6:15:41 PM(UTC)
Páll Bjarkason
Rank: Advanced Member

Groups: extranet\Customer
Joined: 1/13/2012(UTC)
Posts: 156

In the calculated column on the far right the percentage of a single products contribution to the total revenue (measure B) is listed.
I have chosen to show the top 3 products sorted on measure B.
In the calculated row “sum” I have made a sum of the 3 visible measures, but how can I make a sum of the visible percentages calculated column on the far right (i.e. 90,7 % in the black circle) ?

Ideas anyone?

UserPostedImage

Edited by user Thursday, February 16, 2012 6:16:13 PM(UTC)  | Reason: Not specified

Best regards

Páll, CTS
Ole  
#2 Posted : Monday, March 12, 2012 3:46:35 PM(UTC)
Ole
Rank: Administration

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

Hi Páll,

You will have to edit your Sum calculation. If you have used the pre-defined Sum calculation you must click "Edit formula". Once you have done that, you will have an option called "Calculate in intersection". Use the check box to decide that your Sum calculation must work for your Ydelse % column as well.

Best regards,
Ole

UserPostedImage

UserPostedImage

Edited by user Monday, March 12, 2012 3:52:42 PM(UTC)  | Reason: Not specified

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
Páll Bjarkason  
#3 Posted : Thursday, March 22, 2012 11:00:49 AM(UTC)
Páll Bjarkason
Rank: Advanced Member

Groups: extranet\Customer
Joined: 1/13/2012(UTC)
Posts: 156

Hi Ole,

I checked the Calculate in intersection check box and voilà – this solves my problem.
Thanks for your help.

NB Topic is solved and the thread can be closed. Do you know how to?

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

Best regards

Páll, CTS
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