sql - SSRS 2008 - grouping sets? -
if have list object groups tablix according country value in dataset, possible add own custom combinations? e.g. if have uk, france, germany, us, japan boxes, , 1 eu puts uk france , germany in 1 group? i can in sql server 2008 grouping sets, can similar thing done in ssrs? you can add calculated field dataset (right-click on it). in expression it, use switch statement decide group name. can use calculated field in report other field.