Here in this pivot table i want to make disappear those fields but value should be there inside how can we makeup using background color or any other way ...what is the expression for it and where we have to write.
Right click on the cell and choose Custom Cell Format. Then you can make text color the same as background color. This will hide the value but it will still be there. Is this what you wanted to do?
Did this help?
nope can u give me u r mail id i will send the full issue
Retrieving data ...