I have a pivot table which will show my monthly sales.
I have the partial sums(Total)option enabled.
I have to display background color by comparind the monthly sales against goal1 and for the toal sum column alone i have to compare against another field (Goal2).
I tried removing the partial sums and created a calculated dimension.
But i am not able to get the total which i am looking for.
Note : Sales is a division value(eg. A/B)
Could anyone help me on this by suggesting alternate ways.
