Delete or don't show single rows of a pivot table.
HI,
I have a problem with a pivot table.In this pivot table I have an Expression that calculates the difference beetween two values and that are calculated with other expressions in the same table; I want that when this difference is 0 then the intire row has to vanish from the pivot table,all this without modifing the sql script.
I've got the solution just adding an if to all the expressions of the table that sets their value to 0 if the difference is 0 and checking the flag Suppress Zero Values in the tab Graph of table properties!