Grid chart bubble size relative to dimension value

[sifatnabil]

Hi all,

I have a grid chart where the dimensions are (in order) -

Client,

Week

and Expression -

sum(Sales)

The grid chart is sizing the bubbles based on the highest and lowest values of all clients over the time. What I would like is for the bubble sizing of a client not to be affected by other clients.

So if Sales of client A = $50 (highest for client A), and Sales of client B = $1,000 (highest for client B), the bubble size for both clients should be the same. How can I get this?

[swuehl · Accepted solution]

Maybe try something like

=Sum(Sales) / Max(TOTAL<Client> Aggr(Sum(Sales), Client, Week))