Calculate Count in the BEX Query output based on Input date(by User)

[anish_samuel]

Hi Gurus,

We have a requirement to get the count for Account group based on creation date (User Input).

Doc Number;Created Date;Closing Date;Multiple Date;Account group 1001;02.07.2018;20.07.2018;08.07.2018;02

1002;02.07.2018;20.07.2018;05.07.2018;05

Now if I need to run a report to get the count based on Account group.

For example:

Case 1:if my user-input selection created Date(Interval) 01.07.2018 to 06.07.2018 then it should show count ('1') for second record in the report output (for Multiple Block)

Account Group; Unblock ;Multiple Block

02;1;0

05;0;1

Case 2:if my user-input selection created Date(Interval) 06.07.2018 to 12.07.2018 then it should show count ('1') for first record in the report output (for Multiple Block)

Account Group; Unblock ;Multiple Block

02;0;1

05;1;0

Case 3:if my user-input selection created Date(Interval) 01.07.2018 to 04.07.2018 then it should show count for both record in the report output (for unblock) since multiple date is not in the interval range.

Account Group; Unblock ;Multiple Block

02;1;0

05;1;0

Please help to achieve this in Bex Query.

Thanks in advance

Samuel

[anish_samuel]

Hi Gurus,

Any suggestion?

Thanks

Samuel