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,