Hi
CODE(ITEM('G3 Location')) and PARENT(ITEM('G3 Location')) were defined for the following Code and Country results. Is there a 'grandparent' function that can be used to display Region?
Hi @Star ,
You can use PARENT(PARENT(ITEM('G3 Location'))).
Hope, it will help you.
Thanks,
Naushad
Hi @Star,
Suggestion 2 would require the 'Applies to' to be Country List rather than Location list, right?
No, You Don't Want to Change anything. it Works.
You can share your error when you are following this approach.
@prabhu
Yes, it indeed worked. Thanks 🙂
There is no Grand Parent Function.
You can use in 2 ways.
1. PARENT(PARENT(ITEM('G3 Location')))
2. PARENT(Country) Country -> Line Item
Both Result the Same Output.
Sorna Raja Prabhu
It's now possible to use the additional insights to have dynamic filters, however the columns in the table are fixed widths. It's quite unfortunate that the ability is added, but the layout isn't dynamic. I understand that a report is more fixed, but adding dynamic columns would really help make the management report…
There was an error rendering this rich post.
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…
