Cube View - Multiple Columns per Entity

Question

Hello, 
I am trying to change the columns of a cube view so that using entity ChildrenInclusive we get each column sectioned by each entity and in one single tab. We want this to be in one tab, not multiple tabs so I didn't think a book would work.
I was able to make it look like this with these columns members.

However, in the original CV we had specific formatting for the Variance B/W and Variance % columns which I cannot figure out how to apply to the multiple items in the nested column member. This is what I have currently for format. This works, but applies the pink formatting across the first 3 columns when I only want it on the Variance B/W column. Is this even possible?
NumberFormat = [#,###,0;(#,###,0);0], If (RowName Contains FSLI) AND (ColName Contains Entity) AND ((CellAmount > 4000000) OR (CellAmount < -4000000)) Then BackgroundColor = Pink
Any ideas or other ways to go about this?
Thanks,
Megan

db_pdx · Accepted Answer

Hi MeganN: you're on the right track, but need to use a slightly different conditional formatting.

If (ColE2HeaderDisplayText = 'Variance B/W') AND ((CellAmount > 4000000) OR (CellAmount < -4000000)) Then
BackgroundColor = Pink
End If

If we focus on the first conditional:

(ColE2HeaderDisplayText = 'Variance B/W')

This is saying, format based on:

Col = Columns
E2 = Member Expansion 2
HeaderDisplayText = the specific name you're using since you have GetDataCell():Name()

There are similar versions that can be used on the MemberName or MemberDescription as well: ColE2MemberName, ColE2MemberDescription, respectively.

Let me now if that works for you. Cheers, -db

Edit: typos

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded