Need Help..?

[Nagaraju_KCS]

Hi All,

I have a Pivot table having null data. how to remove only column not row's.

if i am check the Suppress Null Values hiding all Zero columns and rows..

but i required all Division's.....

PFA,

Thanks in Advance..........

[Nagaraju_KCS]

Hi Designing Experts,

Anyone face this type of problem...............???????

[its_anandrjs]

Hi,

If you select Suppress When Value is null then Null columns and rows removed but you are not able to see zero column and rows also all division which are zero not shown.

Thanks & Regards

[Nagaraju_KCS]

Hi Anand,

That's why am asking, but i need all Division with Zero values also..

But i am getting extra column..i want to hide that column only....

See the first Image....

[Anonymous]

yes you can set a condition in "dimension" tab to show or hide  a specific column

[#6]

HI,

I believe its not possible to meet your exact requirement. I am eager to see if someone can crack this.

[#7]

try this on your script:

TEST:

LOAD Division,

     if(isnull(Plant),'No data',Plant) as Plant,

     if(isnull(Plant),0,OrderQty) as OrderQty

FROM

Book1.xlsx

(ooxml, embedded labels, table is Sheet2);