Summing visible calculated members

Options

Holbæk kommune - Páll Bjarkason

#1 Posted : Thursday, February 16, 2012 5:15:41 PM

Rank: Advanced Member

Groups:

Joined: 1/13/2012
Posts: 33

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?

Report Abusive | Report SPAM | Edit by user: Thursday, February 16, 2012 5:16 PM | Reason: Not specified

User Profile
Hide User Posts

Dyring - Ole

#2 Posted : Monday, March 12, 2012 2:46:35 PM

Rank: Administration

Groups:

Joined: 4/7/2011
Posts: 111

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

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

Report Abusive | Report SPAM | Edit by user: Monday, March 12, 2012 2:52 PM | Reason: Not specified

User Profile
Hide User Posts

Holbæk kommune - Páll Bjarkason

#3 Posted : Thursday, March 22, 2012 10:00:49 AM

Rank: Advanced Member

Groups:

Joined: 1/13/2012
Posts: 33

Hi Ole,

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

Regards,
Páll

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

Report Abusive | Report SPAM

User Profile
Hide User Posts

Users browsing this topic

- Anonymous