Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
is that simple. thanks for this