I would like to show a pivot view of region split by country and show budget in global i.e. USD and budget in local currency specific to each country as separate columns. The view looks perfect in the fully expanded view as there is no aggregation happening in the measures.
When the country column in collapsed, I would to see budget for each region in USD. I do not want the local currency column to aggregate the values.
Any help would be appreciated. Thanks!