G
Guest
I have a pivot chart based on the following query.
TRANSFORM Sum([Fund Volume]) AS [SumOfFund Volume] SELECT [Month] FROM
[Business Snapshot - Fundings] GROUP BY [Month] PIVOT [Year];
The months are sorting in alpha order rather than calendar order. I tried
an ORDER BY command but it keeps returning an error message. Any ideas?
TRANSFORM Sum([Fund Volume]) AS [SumOfFund Volume] SELECT [Month] FROM
[Business Snapshot - Fundings] GROUP BY [Month] PIVOT [Year];
The months are sorting in alpha order rather than calendar order. I tried
an ORDER BY command but it keeps returning an error message. Any ideas?