How to hide the Unselected values in pivot table

[#1]

Hi,

I am using pivot table

ProductName	Sum (CountingUnits)	Sum ({$1}CountingUnits)
AGX	0.00	20880.00
AS	10604950.00	10604950.00
COGRELH	0.00	57540.00
CLO	0.00	1110.00
CO	0.00	2071520.00
GS	0.00	130830.00
ITOR	0.00	1157500.00
PETIN	0.00	529700.00
PVIX	0.00	807184.00
TAAL	0.00	680800.00
TRO	0.00	174100.00

I have selected the AS in productname field ,it shows the AS value and other values(unselected) with 0.00 ,how to hide the other values showing 0.00

pls,,,help me out.Thanks in advance

[#2]

Hi btechrames,

I'm not sure about your question. But let me guess.

You can try check "Supperess When Value is null" in Dimension tab and check "Suppress Zero-Values" in Presentation tab.

Hope this help,

Tatar

[#3]

Hi btechrames,

I m not sure about your question

If your dimension is ProductName and expression is Sum (CountingUnits) then pivot table sould be as u wants.

if u got problem then post ur app here

thanks

zaman

[johnw]

For your second expression:

if(sum(CountingUnits),sum({1}CountingUnits))

Basically, only calculate your second expression if the first expression is established. That way, BOTH fields will be 0 for the unselected values, so the row can be suppressed. As long as one expression has a non-zero value, you can't suppress those rows.