Question: Is there a way to report the total of a group of members based on a text attribute with multiple dimensions in a row?

[OSCommManager]

Question (cont)

• The example below is for an operating expense that I want to be filtered using a text property of “HP” (a specific business line). I thought the following would work, but it is still pulling in the total company business line, not just a total of the “HP” UD3 members.

A#Marketing:U1#TotalBU:U2#Top:U3#CustomerGroup_0002.Base.Where(Text1 contains HP):Name(Market)

• I don’t need an expansion of the customers (UD3) but a total of the relevant members.

Answer

• Using CVR Math in a cubeview row will not work in this situation.

CVR Math Example

 

•  A Dashboard XFBR String will be needed to aggregate the members with the Text property to produce a total. 

XFBR Example

Source:  Office Hours 2021-02-04 - Partner Enablement