Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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 ?
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.
Ok, try this:
count( {<F1=E({1<F3={'A'}>})>} F1)
Try this also please:
count( {<F3=E({1<F3={'A'}>})>} F1)