Pivot Table

[upaliwije]

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

Pls help me

[its_anandrjs]

You can use like a calculated Dimension

Dimension [Item N0] =if((sum(Sales) And sum(Paid) And sum(Nos)) > 0,[Item N0])

Hope this helps

Thanks & Regards