Consolidate Numbered List table
I needed some help in designing a consolidation table for the input table as attached as image.
i am trying to consolidate the Org Var based on CF Lines,Driver,Driver Groups for the fixed dimensions (in black).
If i use these dimensions (CF Lines,Driver,Driver Groups) ,the model size increases to a huge extent.
The users would like to see the headings as wells of these dimension along with a drop down for Local and USD currency.
Please suggest some ways to get accurate consolidated results .