Hi,
We have a requirement to create P&L report with 6 months of Trailing Period Data, Since the Revenue Accounts , Total Revenue is from different levels of Hierarchy have used union query to show revenue accounts in one union query, Total Revenue in second Union query.
On Applying Sort Descending in the Fiscal Period to show data from latest Month. Sort works without union, on adding second union to the report.sorting on Fiscal Period in report doesn't work.
Is there a way we can apply sorting in the Union query report. below is the report sample layout
Any inputs would be appreciated.
Thanks,
