Expression based on a 2nd IF Color condition data problem

[simongoodman]

I have one block of data with various format styles (e.g 0, 0.0, 0.0%) so I have used IF to build the expression in a pivot table. I also want to add  an IF colour condition to Background Color but it is based on a second block of data.

I can get it to work if the expression is a simple Sum(Data) expression but not when I apply IF to apply formatting. Are there any ideas how to solve this problem?

[simongoodman]

Hi Gysbert

I wonder if I can press my luck and ask for your help again. Another issue has come up when applying this solution to multiple pivot tables.

I have used a variable and buttons to help the user selection process. When the saved qvw is reopened and you make a selecion the IF Color statement table which was on the bottom now appears on the top. Very odd.

The attached example qvw has three selections; Agency Relation, LCO and Customer Service. When saved on the Customer Service and reopened the other selections work. If you then save on the LCO selection and reopen the problem appears. Select Customer Service, resave and reopen presto all is good.

[Gysbert_Wassenaar]

On the Layout tab of the pivot tables that should stay in the background set the layer option to Bottom. As long as the pivot tables with the values are placed in a higher layer they should be displayed on top of the background pivots.