Skip to Content
avatar image
Former Member

calculation on Current week in webi crosstab report.

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Nov 21, 2016 at 10:27 AM

    try something like this in YTD column.

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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

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