Calculate the sum of the week for the current year (eg 2014), but on the condition that if in this same week data were last year (2013).

[antonrus]

Hello Help please! Need to calculate the sum of the week for the current year (eg 2014) but provided that if for that same week had data for the last year (2013). If data for the same week last year was not - sale this week should not be exposed to the sum. And painfully hard ...

[antonrus]

week	1	1	1
RestNum	sum({<RestNum={"=sum({<Year={2013}>}, Summ) > 0"}>} Summ)	2013	2014
55980	0	125 871	149 113
56284	0	229 575	82 243
56525	0	236 492	105 941
59045	0	0	38 485
60385	0	0	77 555
	0	591 938	453 337

I now have shows all zeros .. (I can not ask you but if still possible - attach file structure in the first message - it can accurately check all)

[#3 · Accepted solution]

It is not possible because I have the Personal Edition (I would ahve attached it and done the test with your data)

Sorry for that

Picture 1

A pivot table with the corresponding syntax

A pivot table with Sum(Amount) to show the stucture

Picture 2

The first pivot table, I have added Sum(Amount) to show that the syntax returns 0 in that case

I cannot attach your qvw, you will be able to attach mine. That is the last sheet.

Fabrice

[antonrus]

Seems to happen, I am very grateful to you, thank you very much! You helped me a lot!

[#5]

you are the wellcome