Skip to Content
avatar image
Former Member

Displaying Previous Value Webi

I have the following table:

My dimension is based on a date converted to a number in the format YYYYMM. Measure 2 is calculated as Previous([Measure 1]];12).

I need to display the Dimension DATE YYYYMM and Measure 2 only.

It displays fine but I need to hide all the empty measure so that it displays for only 201701 - 201712. When I unchecked "Show rows with empty measure values" in the table property the table returns no value but it still displays 201701 - 201712.

How can I fix this problem?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Mar 24, 2017 at 11:02 AM

    try these steps if helps you.

    V Date=if(Year([Date])=Year(currentdate())) then RelativeDate([Date];1;YearPeriod) else [Date]

    Drag V date variable and measure1 in the table and see if you will get the exported results.

    Add comment
    10|10000 characters needed characters exceeded