Limiting data in straight table

[mail2bsk]

Hi,

i want to limit data in straight table based on two different conditions.

output table should contain:-

Top 4 Risks from Type (Top N is calculated based on Risk Number and Date) and Issues that are High Priority.

Table structure is as below

Date	Type	Priority	Risk Number
4/3/2015	Risk	High	7
5/3/2015	Risk	Low	7
9/23/2014	Risk	Medium	7
4/30/2015	Risk	High	6
4/3/2015	Issue	High	1
3/30/2015	Issue	High	1
5/20/2015	Issue	Low	1
9/23/2014	Risk	High	5

Thanks,

SK.

[Kushal_Chawda]

What will be the output?

[mail2bsk]

Output would be:

Date	Type	Priority	Risk Number
4/3/2015	Risk	High	7
5/3/2015	Risk	Low	7
9/23/2014	Risk	Medium	7
4/30/2015	Risk	High	6
4/3/2015	Issue	High	1
3/30/2015	Issue	High	1

[sinanozdemir]

Hi,

I might be getting your requirements wrong, but these are not really top 4 types:

As you can see when I use Rank(), these records are top 6 records.

Is that what you are really looking for?

[mail2bsk]

My requirement is to show Top 3 records of Type is Risk based on Risk number and High Priority records where Type Issues.