Skip to Content
0
Jul 06, 2014 at 09:27 AM

HOW TO GET FILTERED DATA

12 Views

HI All,

I have an query, i have data like how to get filtered data


i have data like below


we have started this report with below data for Oct 2014 to Dec 2014


QUARTER STATE COUNT Oct 2014 - Dec 2014 U.P 70 Oct 2014 - Dec 2014 M.P 0 Oct 2014 - Dec 2014 BIHAR 3 Oct 2014 - Dec 2014 MAHA 50 Oct 2014 - Dec 2014 RAJ 3

so it was very easy to generate report

then we get data for Jan 2014 to March 2014

QUARTER STATE COUNT Oct 2014 - Dec 2014 U.P 70 Oct 2014 - Dec 2014 M.P 0 Oct 2014 - Dec 2014 BIHAR 3 Oct 2014 - Dec 2014 MAHA 50 Oct 2014 - Dec 2014 RAJ 3 Jan 2014 - Mar 2014 U.P 77 Jan 2014 - Mar 2014 M.P 1 Jan 2014 - Mar 2014 BIHAR 4 Jan 2014 - Mar 2014 MAHA 77 Jan 2014 - Mar 2014 RAJ 5

so we applied filter on quarter manually for generating the report

now we have data like below

QUARTER STATE COUNT Oct 2014 - Dec 2014 U.P 70 Oct 2014 - Dec 2014 M.P 0 Oct 2014 - Dec 2014 BIHAR 3 Oct 2014 - Dec 2014 MAHA 50 Oct 2014 - Dec 2014 RAJ 3 Jan 2014 - Mar 2014 U.P 77 Jan 2014 - Mar 2014 M.P 1 Jan 2014 - Mar 2014 BIHAR 4 Jan 2014 - Mar 2014 MAHA 77 Jan 2014 - Mar 2014 RAJ 5 Apr 2014 - Jun 2014 U.P 186 Apr 2014 - Jun 2014 M.P 18 Apr 2014 - Jun 2014 BIHAR 74 Apr 2014 - Jun 2014 MAHA 189 Apr 2014 - Jun 2014 RAJ 68

now as per new requirement they want only this quarter data of Apr 2014 to Jun 2014

Apr 2014 - Jun 2014 U.P 186 Apr 2014 - Jun 2014 M.P 18 Apr 2014 - Jun 2014 BIHAR 74 Apr 2014 - Jun 2014 MAHA 189 Apr 2014 - Jun 2014 RAJ 68

and requirement like we have to automate this process . means report should contain only current quarter value.

so my query is how to achieve this

please suggest

I am using SAP BO 3.1

Thanks in advance

Jeet