Hi Guys, I am new to this forum, and not very good in Excel Functions.
I have a requirement where i have to show Aggregation of data at different levels. Following data i attached.
Region State County Revenue
North Montana Madison $10,000
North Minnesota Pine $20,000
North Minnesota Benton $25,000
South Texas Collin $50,000
South Texas Smith $40,000
South Alabama Blount $15,000
East New York Clinton $60,000
East New Jersey Essex $40,000
East New Jersey Camden $35,000
West California Fresno $55,000
West California Imperial $50,000
West Oregon Wasco $30,000
- i have to show only Region with Revenue,and this is without Pivoting in the excel, because i will be taking this data and making as an input to another.
Region Revenue
North $55,000
South $105,000
East $135,000
West $135,000
- Same thing with one more column, with lower granularity
Region State Revenue
North Montana $30,000
North Minnesota $25,000
South Texas $90,000
South Alabama $15,000
East New York $60,000
East New Jersey $75,000
West California $105,000
West Oregon $30,000
If we can capture these scenario at the source data, that's great, or if we have to map it to another place, we can do that as well. But in any case it has be derived using functions.
Thanks so much.
Bookmarks