calculated Items

[Mamdouh Elfors]

Hi
I have a pivot table when I add a calculated item that shows all sources in all processes. How do I get rid of zero sources in each process?

 

[vletm]

Mamdouh Elfors
eg Excel > Preferences.. > View > Unmark 'Show zero values'

 

[Mamdouh Elfors]

Thanks vltem. Your interest is wonderful
But I meant to delete all resources worth zero
Example: There is no need for electricity to appear in pesticides because it is for irrigation
Thank you

 

[Nebu]

Hi:

Can't you just filter on Total Plan Column?

Thanks

 

[vletm]

Mamdouh Elfors
You should write what do You mean ...
Deleting would be a challenge...
but You could hide those rows too.

 

[Mamdouh Elfors]

vltem
You're right, I'm sorry
Sometimes I think I've got the information right. Maybe because I'm old
thank you very much

 

[vletm]

Mamdouh Elfors
Age is only a number!