Forum Discussion
Solved
Dynamic column selection
Hi I'm trying to sum up reservations from sub locations into geographical locations. I always end up with errors when updating the model, because one of the sub locations in the model doesn't ha...
It's partly my fault... :smileyembarrassed:
My fault: Record.ReorderFields will also select all other fields in your table.
Your fault: you omitted the Record. part of Record.ReorderFields.
Solution: use Record.SelectFields instead of Record.ReorderFields.
Simply adjust all your ReorderFields to Record.SelectFields and keep the rest as is.
Can't you use grouping feature available on few of the charts?
Also you can create groups and then create measure to sum up columns which are part of group to make it dynamic. I think way you are trying to sum up will hard code things and eventually it will run into issues.