Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ...
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)
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
Seems to happen, I am very grateful to you, thank you very much! You helped me a lot!
you are the wellcome