This is moving in the right direction I think, however, I have multiple
dimensions that need to be fixed, not just country name. Is that possible?
On Wed, Jun 20, 2018 at 7:56 PM Lei Chen <email@example.com>
It's possible to use multiple dimensions after FIXED.
There might be more solution alternatives depends on the data.
It would better if you could provide some sample data or a sample workbook.
Just jumping in to let you know I'd like to help too - here's our Australia Expenditure data viz for inspiration https://www.aihw.gov.au/reports/health-welfare-expenditure/health-expenditure-australia-2015-16/contents/health-expendit…
I'm thinking you could also create a calculated field along the lines of;
if [Parameter] == [Year] then [Year] else max([Year]) end
But yeah, what Lei said - we need to see some data