Skip to Content

calculation on Current week in webi crosstab report.

Nov 21, 2016 at 09:52 AM


avatar image
Former Member

Can any one provide a solution to achieve this.

We have a cross tab with region in rows and week in columns. In addition we have to display a YTD Target of current week in Columns which is coming from a different query.

There are few more parts involved in this report but we are stuck with the calculation of the YTD of the current week, which is based on 2 quey and can not be done from the higlited blue area.

2fuoa.png (16.9 kB)
n20zr.png (18.7 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Nov 21, 2016 at 10:27 AM

try something like this in YTD column.

=Sum([your variable]) where ([Week Object]=Week(CurrentDate()))

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

This will provide the Current Week Data of the table and will not include the calculation logic.