Skip to Content

Scenario based Report Development with cross tab

Feb 28 at 10:41 AM


avatar image

Hi all,

I have below data in database:

Account Sub-Account Balance Date Balance
A PQR 22-02-2018 56
B LMN 28-02-2018 23
B LMN 27-02-2018 34
B LMN 25-02-2018 45

I want to develop a webi report with below structure. The report must contain filter 'Balance date is greater than 24th Feb, 2018' and if the data is not present for the given filter it should show Last Balance value:

25-01-2018 See previous balance 45
26-01-2018 See previous balance See previous balance
27-01-2018 See previous balance 34
28-01-2018 See previous balance 23


Last balance 56 23

I have designed a report but I am getting below structure. As per the condition even if data for account A is not present after 22nd Feb, 2018; its should show Last balance which was of 22nd Feb.

25-01-2018 45
26-01-2018 See previous balance
27-01-2018 34
28-01-2018 23
Last balance

It's not showing data for Account A because data for Account A after Balance date 24th is not present in database. And the filter I have applied is must.

Please help.



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

0 Answers