 Rank: Advanced Member
Groups: extranet\Forum
Joined: 4/8/2011(UTC)
Posts: 68
|
Hi How do I remove color-agents from total?  I would it to look like this  |
Best regards
Lotte Bjørn
|
|
|
|
|
|
 Rank: Administration
Groups: extranet\Forum
Joined: 4/7/2011(UTC)
Posts: 433
|
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.  Ole Dyring |
|
|
|
|
|
Rank: Advanced Member
Groups: extranet\Forum
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
|
|
|
|
|
|
Rank: Administration
Groups: extranet\Forum
Joined: 4/7/2011(UTC)
Posts: 433
|
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. Ole Dyring |
|
|
|
|
|
Rank: Advanced Member
Groups: extranet\Forum
Joined: 4/8/2011(UTC)
Posts: 68
|
Hi Ole You can't or I can't :-) summarize an index, you have to calculate it  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
|
|
|
|
|
|
Rank: Advanced Member
Groups: extranet\Forum
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 ;-)  Best Regards, Peter
|
|
|
|
|
|
Rank: Administration
Groups: extranet\Forum
Joined: 4/7/2011(UTC)
Posts: 433
|
Hi Lotte, I have made an example here, with a calculated New Total row and a calculated Indeks column.  Notice that the intersecting cell between the two calculations is empty by default. Next, I go into the Indeks calculation to "Calculate in intersection".  Finally, I check the New Total check box.  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. Ole Dyring |
|
|
|
|
|
Rank: Advanced Member
Groups: extranet\Forum
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
|
|
|
|
|
|
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.