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?
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
Updated 2 years ago
Version 2.0