Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have 18 straight charts grouped into 6 sets, so each set has 3 charts. Each chart has one Dimension (client) and one Expression (Sales). Need to create a Macro that reads each set (3 charts at a time), count the number of times Clients appear in each set, if:
Count(Client) = 2, make the background color of that row (Dimension and Expression) Blue
Count(Client) = 3, make the background color of that row (Dimension and Expression) Green
Then read the next set and so on.
Attached is the sample.
Any suggestion would be appreciated.
Thank you.
See attached example.
Thank you G Wassenaar, I can't assign Table and Group fields in the data model because of it's size and complexity.
Trying to achieve the grouping on front-end (sheet level)