This content has been marked as final. Show 3 replies
I have a simple table:
I want to compare two columns dynamically, e.g. Actual vs Budget for 2012, Actual Apr vs Actual May, etc
I have tried hard coding the expressions:
They worked fine to show me the difference between Actual and Budget, and I know same will apply for Year and Month.
What I want now is to extend this so that I can have 2 list boxes of ABF, and and pick the 1st one as left hand side, the 2nd one as right hand side, and the pivot chart can display the 3 columns accordingly. I need some enlightenment as it just sounds like an easy piece of homework on set analysis. Any help would be appreciated.