Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a pivot table with subtotals in different dimensions.
I select a predeterminate style for the pivot table and I see that perfectly with colors, but after I add other columns in the same pivot table and the subtotals of these columns don´t have the same color that the other columns <<Target Cost>>.
How can I solve it?
Thank you
Maybe you used several different layout-methods - the predefined styles intab design, visualizations from tab visualizations, formatting-conditions on dimension/expression-level (+ sign by each dimension/expression) and/or customize cell layouts (right click on a table-part and there about the mid) - and there is some inconsistency especially that these four methods have a different priorities.
- Marcus
No I applied only the option predeterminate style for the pivot table and only one expression have a distinct color.
If only this predefined style is used it shouldn't be happens. Could you change the style and afterwards rechange again to your previous one?
- Marcus
I do it but the expression the subtotals of these columns don´t have the same color that the other columns
Then the pivot might be corrupt and needs to be new created (new object, choose dimension, copy+paste from labels and expressions and so on - maybe with notepad as intermediate step). But before make sure that there is really no other layout applied (it might be created a long time ago and forgotten now).
- Marcus