Skip to Content
Former Member
Oct 02, 2008 at 09:41 AM

discontinued value, first date in month



I have one measure Sales Revenue and I need it to show it in two columns in report. In one column have to be Sales Revenue for week and in other Sales Revenue for week-1

I solved it in webi - i did two queries and one prompt. The one query containes only dimensions week, the second query containes week-1. In prompt I put only one value.

Queries are ok, but the output in report containes one values, which is discontinued and I don't know, what does it mean?

The second question is: How can I show the first day of the month?

Thank you for your answer. Have a nice day,