i've managed to simplified the source file in order to post it.
basically i'm comparating the perfomance of some ItemID between the actual date and some days before (180).
I can display the difference of actual and old very well in the first chart, with dimension ItemId or Item_Group.
I can display it also in a Text box.
But when i'm gonna to display the same expression over the Week, it doesn't work. (bottom chart) !
How can i achieve that?
Ps: if i select a week the value is correct, but i want to show how the gap in going over the weeks...
download @ http://www.filedropper.com/aggrtest
I've tried to implement The AsOfTable but i'm getting the same result.
My expression work perfectly when is in a Text box or in a bar chart with ItemID.
When i put it in a chart over Week it doesn't work anymore. Moreover, if i select the Week with a filter pane the value in the chart is displayed correctly.
What is the reason of this behaviour?