en
Welcome Guest! To enable all features please Login or Register.
Options
Go to last post Go to first unread
Lotte Bjørn Jensen  
#1 Posted : Thursday, July 10, 2014 1:50:19 PM(UTC)
Lotte Bjørn Jensen
Rank: Advanced Member

Groups: extranet\Customer
Joined: 4/8/2011(UTC)
Posts: 68

Hi

How do I remove color-agents from total?

UserPostedImage

I would it to look like this

UserPostedImage
Best regards

Lotte Bjørn
Ole  
#2 Posted : Thursday, July 10, 2014 2:30:17 PM(UTC)
Ole
Rank: Administration

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

Hi Lotte,

I think the easiest way to accomplish this, is to insert a calculated row: sum(0, all, 0). You will also need to define "Calculate in intersection" for your calculated columns.

The calculated row will not pick up the color agents.

BR / 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.

UserPostedImage Ole Dyring
Lotte Bjørn Jensen  
#3 Posted : Thursday, July 10, 2014 3:08:24 PM(UTC)
Lotte Bjørn Jensen
Rank: Advanced Member

Groups: extranet\Customer
Joined: 4/8/2011(UTC)
Posts: 68

Hi Ole

That works fine, except for the "indeks" columns, because it's calculations like this: sum(d1,0,m1)*100/sum(d2,0,m1).

Other ideas? :-)




Best regards

Lotte Bjørn
Ole  
#4 Posted : Friday, July 11, 2014 8:25:14 AM(UTC)
Ole
Rank: Administration

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

Hmm. I don't see why it doesn't work? When you add your calculated row, initially all the Indeks cells will show up blank. Then, by going into each of the Indeks calculations, you should be able to "Calculate in intersection" to get the correct result. Or is "Indeks" not a calculated column?

Edited by user Friday, July 11, 2014 8:28:34 AM(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
Lotte Bjørn Jensen  
#5 Posted : Friday, July 11, 2014 1:30:04 PM(UTC)
Lotte Bjørn Jensen
Rank: Advanced Member

Groups: extranet\Customer
Joined: 4/8/2011(UTC)
Posts: 68

Hi Ole

You can't or I can't :-) summarize an index, you have to calculate it

UserPostedImage

The index should be 100 (28.026.393*100/28.002.857)
but it is 1.180 (115+112+110+102+102+100+95+87+85+84+84)



Best regards

Lotte Bjørn
Peter  
#6 Posted : Friday, July 11, 2014 1:34:54 PM(UTC)
Peter
Rank: Advanced Member

Groups: extranet\Customer
Joined: 4/1/2011(UTC)
Posts: 43

Hi Lotte

You can try and change your color agents a bit.

This is my attempt on a elegant solution ;-)

UserPostedImage

Best Regards,

Peter
Ole  
#7 Posted : Friday, July 11, 2014 1:47:04 PM(UTC)
Ole
Rank: Administration

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

Hi Lotte,

I have made an example here, with a calculated New Total row and a calculated Indeks column.

UserPostedImage

Notice that the intersecting cell between the two calculations is empty by default.

Next, I go into the Indeks calculation to "Calculate in intersection".

UserPostedImage

Finally, I check the New Total check box.

UserPostedImage

Notice that the Indeks for New Total is 111 - not the sum of country indexes.

BR / Ole

Edited by user Friday, July 11, 2014 1:52:01 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
Lotte Bjørn Jensen  
#8 Posted : Friday, July 11, 2014 2:17:19 PM(UTC)
Lotte Bjørn Jensen
Rank: Advanced Member

Groups: extranet\Customer
Joined: 4/8/2011(UTC)
Posts: 68

Hi Ole and Peter

Thanks for your solutions, both working. :-)

Have a nice weekend
Best regards

Lotte Bjørn
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