Skip to Content
0

Displaying Previous Value Webi

Mar 24, 2017 at 10:12 AM

46

avatar image

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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

AMIT KUMAR
Mar 24, 2017 at 11:02 AM
0

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.

Show 3 Share
10 |10000 characters needed characters left characters exceeded

I get the following error:

Note that I need to display the column in format Year and Months only.

webi-capture-5.png (16.3 kB)
0

it seems you are below then BI 4.1 SP06. Period function are introduced from BI 4.1 SP06.

0

Yes. It's BI 4.1 SP04.

0