Dynamic Filter in Web Intelligence
I need help about one issue. Let me explain my problem:
I have a webi report, this report contain the sales by day. The problem is that my variable of day contains values from current month, last month and month of las year. Example:
My variable of day has this behavior because i need to compare the sales of current month vs las month and current month of last year.
The measure that has the sales is database delegated.
In other view of my report, i need to show only the sales of current month, but when in my webi report filter the sales with the condition "is not null" (to hide the information about last year and last month) the intersaction between day and sales show me the following message:
Sales: #NOT AVAILABLE
I really need to reach this behavior, but i dont know how to do to work my filter.
Someone can help me please?????
I am using BO XI 3.1 SP3