Pivot Table / Selection explanation

[#1]

Hi! I create a pivot table. I need an explanation about:

1) How can I hide the records where 2011 fields are null/zero?

2) How can I show only records where department fields are C or D?

You can find an example attached.

Any suggestions greatly appreciated.

Andrea

[alexandros17 · Accepted solution]

1) To hide a record yoou need to have all the values on the row set to zero, so in other columns you must test:

If(column(1) = 0, 0, expression) in this way you can go in tab presentation (properties of the object) and check "set all values to zero"

2) in dimension write:

if(department = 'C' or department='D', department, null())

and check the "suppress when value is null"

Hope it helps

[#3]

Can you help me with an example pls?

[MK_QSL]

Instead of Department use below as calculated dimension and tick suppress when value is Null

=IF(Department = 'C', Department,

  If(Department = 'D', Department))

[#5]

Similar to what Manish explained. See attached.

Thanks

AJ

[alexandros17]

for the second point just copy this: if(department = 'C' or department='D', department, null()) and paste in the dimension ... then check the box as I said before

for the first point, in all the expression after the first write:

If(column(1) = 0, 0, myexpression) and change myexpression with the expression you have written in the column

[#7]

Thank you for you help!

Can you show me how can i hide the 2011 fields where the value is zero, pls?

[#8]

Thank you for you help!

I try to hide all the values set to zero in the example attached, but I don't know where I made a mistake.

Can you take a look pls?

[alexandros17]

Unfortunately I can't see any attachment ...

[#10]

Here it is