I have created a pivot table and I have extracted following report from it
RISK_YEAR
2011
2012
2013
Item N0
Sales
Nos
Paid
Sales
Nos
Paid
Sales
Nos
Paid
18
-
-
-
-
-
-
47,979
1
188,875
19
17,489
1
100,390
-
-
-
-
-
-
20
-
-
-
-
-
-
43,924
1
16,650
21
-
-
-
-
-
-
17,597
1
27,531
22
-
-
-
12,578
1
1,400
-
-
-
23
65,777
2
138,982
-
-
-
-
-
-
24
63,554
1
22,500
63,554
2
36,100
63,554
3
28,500
25
-
-
-
-
-
-
26,805
1
6,200
26
-
-
-
62,255
1
12,500
-
-
-
27
9,870
1
14,500
-
-
-
-
-
-
28
-
-
-
-
-
-
35,788
1
72,900
29
34,399
2
295,100
-
-
-
-
-
-
30
-
-
-
8,955
1
20,000
-
-
-
31
-
-
-
10,703
1
11,688
-
-
-
32
-
-
-
-
-
-
37,475
1
8,100
33
-
-
-
15,209
1
16,200
15,209
1
23,250
34
-
-
-
22,334
1
63,637
-
-
-
35
19,964
2
28,000
-
-
-
22,274
1
31,000
36
14,659
1
91,050
-
-
-
-
-
-
37
-
-
-
-
-
-
38,324
1
39,500
38
-
-
-
-
1
22,000
-
-
-
39
-
-
-
-
-
-
59,711
1
10,770
40
-
-
-
-
-
-
115,730
3
28,000
41
10,596
1
4,800
-
-
-
-
-
-
42
-
-
-
-
1
37,000
-
1
29,800
43
55,108
1
8,000
51,108
4
21,833
51,108
1
80,396
To extract above report I have written following expression
only(SALES)
count(DISTINCT(Nos))
sum( PAID_AMOUNT )
Now I want to write an expression to return records which are highlighted above Row No 24 and 43. In other words records where Nos appear in all three years 2011,2012 and 2013
