Set analysis & Calculated dimensions

[#1]

Hi all,

in a grid chart, I've got calculated dimensions:

- aggr(sum(mysales),account.code)

- aggr(sum(mysales),account.code) / aggr(sum(allsales),account.code)

My expression is simply "account.code".

This works fine for me when no selection is made; the problem comes when an account code is selected: all excluded accounts disappear. My objective is to use a kind of a set analysis maybe to keep all accounts (other solutions are welcome of course).

Thanks in advance for your help,

Marwen

[sunny_talwar]

Try this:

Only({<account.code>} account.code)

[sunny_talwar · Accepted solution]

You might also need the same thing in your dimension:

- aggr(sum({<account.code>}mysales),account.code)

- aggr(sum({<account.code>}mysales),account.code) / aggr(sum({<account.code>}allsales),account.code)