I want to precalculate and distribute via mail using Broadcast and a Control Query a Web query with in rows Cost Center, in column Amount with the detail of six columns rolling month. The user must have the possibility of select the starting month and then the system adjust the corrisponding columns for the other months (so if he select in drop down 02.2006 it will obtain 6 columns from 02.2006 to 07.2006).
I am not able to obtain it, because precalculation does not seems to take into account Variables, and I have always obtained this rolling via Offset with variables.
Any valuable suggestion will be rewarded.
Thank you in advance.
no ideas about this problem ?
Thank you again.
Message was edited by: