Well after some considerable thought, the only way I can think of getting this to work is to pre-summarise the data across your one, two, three categories. Then when you load the data into VA you can change your aggregated measure to just a measure as it now can be dealing with only one row of data instead of multiple rows. A non-aggregated measure can be used in a custom category.   Of course, this isn't going to work if you want to have a different level of aggregation like just say your categories one and two. Possibly you could explore the idea of creating a different data source for each level of aggregation but that is starting to sound messy.   BTW, what type of VA report are you using this data in?   Maybe there are some more experienced VA users out there you can think of a smarter approach. ... View more