on 01-20-2015 8:07 AM
Hi,
I want to filter a measure by using an existing filter in the universe.
My filter is like this:
DateUser:
@Select(Sales\Calendar Day) = @Prompt('Date:','D',,Mono,)
What I want to do is to create a measure by using this filter.
SUM
(
CASE
WHEN DP_Sales.CalendarDay >=
TRUNC (@Where(DateUser),'mm')
AND DP_Sales.CalendarDay <
TRUNC (@Where(DateUser))+1
THEN DP_Sales.Value
END
)
This gives an error like : "Syntax error : expected something between ')' and '='.
If I write a prompt (@Prompt('Date:','D',,Mono,Free)) instead of @Where(DateUser) it work as expected.
How can I use an existing filter instead of writing prompts again?
Thank you!
Anyone?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.