en
Welcome Guest! To enable all features please Login or Register.
Options
Go to last post Go to first unread
Allain Bøge  
#1 Posted : Thursday, July 4, 2013 10:05:45 AM(UTC)
Allain Bøge
Rank: Advanced Member

Groups: extranet\Forum
Joined: 8/15/2012(UTC)
Posts: 13

I have a cross table with Turnover, and a formula calculating the turnover in % (% del) of the total turnover

The problem comes when i want to make a accumulated sum of this (ACC), i can make a accumulated sum of all measures, but not of the calculations


Item Item Name Dk Turnover_DKK % del acc
67131 JM Prestige Handle Long 100-170 cm 3.371.367,74 1,01 1,01
29375 Aluminiumsskaft, 1505 mm, Hvid 3.212.176,25 0,97 1,98
475552 Autobørste, m/vandgennemløb, 270 mm 3.209.036,98 0,97 2,95
29373 Aluminiumsskaft, 1505 mm, Blå 3.097.535,78 0,93 3,88
524752 Vaskebørste m/vandgennemløb, High/Low, 270 mm 2.813.893,66 0,85 4,73
29385 Glasfiberskaft, 1505 mm, Hvid 2.773.252,76 0,83 5,56
297552 Teleskopskaft, aluminium, 1590, 2800 mm 2.454.616,26 0,74 6,30
29374 Aluminiumsskaft, 1505 mm, Rød 2.279.561,40 0,69 6,99
77545 Gulvskraber m/udskiftningskassette, 600 mm, Hvid 2.236.296,25 0,67 7,66
296218 Topreguleret teleskopskaft m/klicksystem, aluminiu 2.146.408,41 0,65 8,31
475752 Autobørste, m/vandgennemløb, 370 mm 2.045.056,95 0,62 8,92
29383 Glasfiberskaft, 1505 mm, Blå 1.790.916,38 0,54 9,46
707852 Wipe-N-Shine, 350 mm 1.714.079,93 0,52 9,98
67111 JM Aluminium Flat Frame, 40 cm 1.697.904,16 0,51 10,49


any idea of getting to this result, of course i can export it to a spreadsheet, but that is not the idea

Kind regards

Allain Bøge
Vikan A/S
Allain Bøge  
#2 Posted : Thursday, July 4, 2013 10:07:00 AM(UTC)
Allain Bøge
Rank: Advanced Member

Groups: extranet\Forum
Joined: 8/15/2012(UTC)
Posts: 13

Danm, the formatting was better when i wrote the topic
Ole  
#3 Posted : Thursday, July 4, 2013 10:15:07 AM(UTC)
Ole
Rank: Administration

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

Hi Allain,

Next time, try a screenshot. :-) See "Announcements from Administrator" on how to insert images in forum topics.

If your "% del" calculation is your first calculated column, you can refer to this as your "c1" column.

To make an accumulation on that column you should do something like this:

sum(c1, d1:0, m1)

Best regards,
Ole

Edited by user Thursday, July 4, 2013 10:15:49 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
Allain Bøge  
#4 Posted : Thursday, July 4, 2013 10:35:38 AM(UTC)
Allain Bøge
Rank: Advanced Member

Groups: extranet\Forum
Joined: 8/15/2012(UTC)
Posts: 13

Yep, that worked, thanks a lot Ole
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