Compensation : Variance by LOB and CC

[csoroka]

Is it possible to sort this report so if it is run for all LOB that CHN always shows up first?

[AVHuntley]

In an attempt to make a quick and simple fix, I adjusted the sort order of the LOB dimension so that [Combined CHNCT] is above [Total FDN]. This causes the former (and all its children) to appear above the latter (and all its children).

Looks like this:

If that's what you'd like, then problem solved. Otherwise, we can probably adjust the row script to more carefully define what order members show up in.

[AVHuntley]

We'll adjust MDX to hide unnecessary rollups

[AVHuntley]

Okay, we've adjusted this row script AND those for the parallel reports:

• Comp Variance by LOB and CC
• Variance by LOB and CC
• Variance by LOB and CC with Salary

Now they all look like this:

[csoroka]

Look good