You need to compare the periods in the table (the table multiple columns)

[Anonymous]

Hi all.

Can't understand how you can compare two periods in the table without having to select points.

file, example attached.

Please help

(the table multiple columns)

[mohamed_ahid]

HI

can you explain more ?

[Anonymous]

Hi,

There is a table,

the first column is the week,

the second is a list of medical offices,

third - the number of works

fourth, we need to calculate the sum for the week

the fifth is to calculate the difference between weeks

goal is to look at the dynamics (gain, loss)

[mohamed_ahid]

what do you want to achieve ? and what stops you ?

[Anonymous]

Hello again )

I want

learn to compare the results of the two periods to compare (plus, minus).

Stops

can't understand how the table to choose the data by week and previous week

[mohamed_ahid]

you have to use a set analysis expression in which you have to specify week =week-1 as condition .

i'm not sure thar i got your point .

do you have a sample file ?

[Anonymous]

Thank you for your attention,

I attach the file !

[sunny_talwar · Accepted solution]

Try this expression for difference:

Sum(TOTAL <Week>[Count(MedicalJournalId)]) - Aggr(NODISTINCT Above(Sum([Count(MedicalJournalId)])), Week)

PFA the application also.

Best,

Sunny

[Anonymous]

Thanks to You, I understood the concept

More positivity and success