See picture below:
1- In Brio I have a pivot that contains one calculated field. This calculation is the division of two fields in the query. In Brio these two columns have been added to the pivot but I have an option to hide them. There is no need to see these two columns when I only want to see the calculated Utilization.
In Toad 5.3 I can make the calculation with the formula shown. This is to work around an error that is fixed in Toad 5.6. But I had to add the two other columns. I cannot hide them.
The only thing I can do is remove the columns instead of hiding them. But this breaks the calculation and I get an error. This does not occur if I have a calc that is just adding column values together. I believe this is because I have to use the "Use Summary values" Option. The columns need to be summarized before the calc is applied.
IS THERE A WAY TO HIDE THE COLUMNS IN THIS SCENARIO?
P.S. It looks like the "Use Summary Values" Option is missing in Toad 5.6. Where did it go?
P.P.S. In the Brio workbook I am converting, I have 12 pivots with 30+ similar calculated field issues. So it gets pretty hard to read the calculated columns.