Issue with RTF Template – Pivot Table Merging
Summary:
we are using a Pivot Table to display invoice data for suppliers across different legal entities over a six-month period (from the given reference period).
Issue:
When the same supplier exists across multiple legal entities, the Pivot Table merges these entries into a single cell. We have attempted multiple options to prevent this merging and keep the data for each legal entity separate, but none have worked.
Attached the report generated and expected output for reference.
We would appreciate your guidance or a recommended solution to resolve this issue.
Thank you,
Content (please ensure you mask any confidential information):