I have a relative easy question for the community.
I'm creating a "Container report", which shows the current stock value shipped in containers used for the customer to move his products; listing the Container value in function of the Country and the Year. I have made a cross-table with those dimensions and a ratio (container value).
Country | 2013 | 2012 |
Austria | value | value |
Bulgaria | value | value |
and so on...
I want to add a right-handed column to show the difference between the stock value shipped in containers between 2 years. For this purpose I had defined some variables:
- MaxYear as:
defined as: ratio (if I try to define it as Dimension, Webi throws an exception and force it to ratio)
- MinYear as:
defined as: ratio
and finally the values according to the year:
=([Value] Where ([Year] = [MaxYear]))
Defined as: Dimension
Output: If I set up a table with Country and MaxYearValue, the data showed is the sum of the 2 years. But, take the formula into account, I have done a subset of the dimension through the Where condition (=2013).
Same behavior as MaxYearValue.
- To finally define a "Difference" ratio, just the subtraction between MaxYearValue and MinYearValue
There's something I have been done wrong, but I don't know where and why.
An idea or suggestion will be welcomed.
Thank you for reading, and thanks a lot for the replys