Calculate only one figure

[#1]

Hi,

I have made a diagram (see below). Now I want to calculate (column3) with a formula like column(1) divided through the only one figure (here 1.759). I need this to see the login usage from the users which have registrated their product in January 2013.

When I filter February 2014 I want to see the calculation for this figure and so one.

Hope someone could help!

Best regards,

Armin

[alexandros17]

suppose column 1 is sum(field1) and column(2) is sum(fiels2) then

column3 is: sum(field1) / sum({$ <KAL.Jahr={'2013-Jan'}>} field2)

[kristof_j]

What if you put this formula in your last column

sum(# logins)/ count( distinct {<KAL.Jahr={'2013-Jan'}>} TOTAL users)

[its_anandrjs]

Hi,

Write some thing like for your field

if(KAL.Jahr = '2013-Jan', Column(1)/ 1.759,0)

Thanks & Regards

[#5]

Thans for your answers ... but perhaps I have described my problem wrong.

In my app I chose e.g. Jan 2013 and see 3.611 Regs. (Table 1)

In Table 2 I want to see the login development of these 3.611 Regs with the formula

count (DISTINCT{$1<JAL.login_success={">=1"}
, ASP_DIMENSIONS.ESTAT_USER.CAMSID=P({$<ESTAT_REG.ZZ_COUNT_REG={1}>} ASP_DIMENSIONS.ESTAT_USER.CAMSID)>}
    ASP_DIMENSIONS.ESTAT_USER.CAMSID) 

Table 1

Table 2

When I chose February 2013 table 2 seems empty: