Hello All,
I am developing a report to determine compliance of systems. where in I need to have total records (5021). I want to filter (Dynamic filter) on the top 2 records, in this case it would be (034 and 019 entry) which would remove 4717 records from the total records. I want to create a bar graph that shows that there are total 304 systems that are not compliant and have 4717 records that are compliant along with the grand total of 5021
where in I have the below data set. I want to filter
Systems Ver Number of Records
A 2011-03-02 rev. 034 4,639
B 2011-03-02 rev. 019 78
C 2011-03-02 rev. 004 163
D 2011-03-01 rev. 019 123
E 2011-03-01 rev. 003 15
F 2011-02-29 rev. 035 3
