Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to know how to hide perticular coloumn in pivot table containing value as null.
In my pivot table I'm calculating some expression after calculation row gets displayed at subtotal coloumn which wont contain any field name (only null symbol) but values exists there .I want to remove perticular coloumn
Hi,
Attached the Screenshot for your reference. As per the excelsheet if you want to hide the row that was showing null you can enable the checkbox Supress when value is Null for the dimension =if([Support Month]<>'*',[Support Month]) .
.
Hi ,
Thanks for reply but this option I had already checked .In this which affects on calculations
see first value it changes fro 16.67 to 18.18.
So this is not fesible solution.
Hi Gokulthube,
Yes the values are getting changed . Not only 16.67 to 18.18.
Since when you have transposed (Soldmonth) the rows to columns. So many values has been changed. If you can share the buisness logic may be if not me some one will be able to help to achive the same.