Better way to aggregate fields in a dimension

[#1]

Hi averyone,

I currently use this calculated dimension:

=if(organization='ABC', Client, organization)

The reason is that I need to set the clients in the organization "ABC" as organizations themselves.

Can i do that in the script, without putting that calculated dimension in every object?

Also better would be to have to possibility to switch through the two options:

1. ABC organization, clients as clients

2. clients as organizations

Thanks so much!

Matteo

[fdelacal]

can you add a qvw. ??

[#3]

Sorry I can't I am using real corporate data...

I add an excel which explains better (I hope)

[fdelacal]

I THINK YOU NEED THIS.

SEE ATACH