I have create a BI time connection formula filter and I have hooked a grid to it.
In the grid I have a calendar hierachy on columns. The grid show average for year level.
In the connection formula i wrote:
When i select, for example, '2011-04-30' in the BI filter, i would like to see the average value for 2010, average value for 2011 from january to april and the value on month level, but for 2011 I see the average value for all month (not only from jan to april).
How can i do this?