Hi All
Here's my situation. I have the following table
A sample of the values would look like this
My goal is to have a matrix with the field "Harvest" at the line and the sum of "Volume" and average of "price" at the value fields (so far so good) with a group of columns. The problem lies on that. I need one first collumn with the values of the contracts registraded at the time the rerport is beign generated. And other column with the same values but distributed on month and year of the "delivery_period".
Should looks something like this
But I cannot find how to create the collumn "Today's business". I tried to create two measures using calculate, but when I insert the measures on the table I receive a new column at the "Delivery Period" group.
I'd appreciate any help I got.
Thanks everyone
