Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Match report function not working as expected — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Match report function not working as expected

Accepted answer
31
Views
8
Comments
edited Jan 24, 2023 8:41PM in Narrative Reporting 8 comments

Summary:

I'm building a report against Planning. The Period dimension has one hierarchy of months under quarters and then alternate hierarchies for YTD. Example: children of Q1 are Jan, Feb, Mar (primary members) and children of YTD(Feb) are Jan and Feb (shared members). Report has period in the POV and a column showing current POV period selection - this works. I need to add a second column to show the YTD amount for the same current POV month. With the POV set to Feb, I tried using Match in multiple ways as listed below. In all cases the Match With setting

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!