Filter the balance based on group

[pranubitla]

The below straight table shows the dimension is period (12 months) and expression is balance.

Now want to add a Group field as well

Group filed has two groups which is  Group A and  group B so the balance filtered in to Group A balance  and Group B balance on month wise.

the resulting table would be

Period

Group A balance

Group B balance

total balance

please help to filter the balance by group

[pranubitla]

is that simple. thanks for this