Single column need to expose for adhoc reporting from aggregate table
In database we have aggregated sales value at different geography level. I'm pulling data like sales at geo hierarchy1,sales at geo hierarchy2 ans so on. Concatenating all the aggregated table and getting multiple sales columns at diff. geo hierarchy level for adhoc reporting. Is there any way we can expose only single sales column which will be driven autometically based geo hierarchy selection.