Skip to Content
avatar image
Former Member

Scenario based Report Development with cross tab

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:

A B
PQR LMN
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.

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


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.

Thanks,

Kushal

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers