get null rows based on one field value

[prasadreddy]

Hi Team,

Can any one provide some help on my task.

I have a pivot table having three fields as below,

F1, F2 and F3 field having values A, B, C, D. I have given count(F1) as expression, output like came as below.

F1	F2	A	B	C	D
X1	Y1		1	1
X1	Y2	1	1	1	1
X2	Y1		1		1
X2	Y2		1	1	1
X3	Y1	1	1	1
X3	Y2	1	1	1	1

But, I want take only the rows associated to yellow cells, which means if the Field F3 Value A having null count, I want to display only those records in pivot table.

Expected out put like below:

F1	F2	A	B	C	D
X1	Y1		1	1
X2	Y1		1		1
X2	Y2		1	1	1

Thanks in advance.

Please provide any quick help.

Thanks,

Sampath.

[YoussefBelloum]

Hi,

do you pivot the F3 field ?

I think when your F3 field Value A is null, it means that there is no A actually on that field, so it will load only B,C and D values, and you will have 3 columns when you pivot F3.

I'm I right ?

[prasadreddy]

Hi Youssef,

No, in the first table I have given expression as Count(F1), the out put came as first table.

But I need to exclude the records if the Filed values 'A' has some count. and want to show only the A value associated to null.

Expecting the second table records.

Thanks,

Sampath.

[YoussefBelloum]

Ok, try this:

count( {<F1=E({1<F3={'A'}>})>} F1)

[YoussefBelloum]

Try this also please:

count( {<F3=E({1<F3={'A'}>})>} F1)