Hello All,
I have been searching through the forums for something that would be able to answer my issue but with no success :banghead:.
I would appreciate if someone could point me to the right thread or take a look at my issue.
I have the following query:
SELECT [In Hours].Outcome, Count([In Hours].Outcome) AS CountOfOutcome
FROM [In Hours]
GROUP BY [In Hours].Outcome;
Which gives me the following table that is exported to excel.
In Hours OverviewOutcomeCountOfOutcomeAnswer18323Assessor Unavailable20775Caller Disconnected703Engaged208Partner Returned240Remained in IVR4090Ring No Answer140Transfer to Partner3881
The issue I have is that I need there to be a grand total at the bottom of the table rather than Excel having to do it. Is this possible?
Thanks for looking and thanks in advance for any help.
I have been searching through the forums for something that would be able to answer my issue but with no success :banghead:.
I would appreciate if someone could point me to the right thread or take a look at my issue.
I have the following query:
SELECT [In Hours].Outcome, Count([In Hours].Outcome) AS CountOfOutcome
FROM [In Hours]
GROUP BY [In Hours].Outcome;
Which gives me the following table that is exported to excel.
In Hours OverviewOutcomeCountOfOutcomeAnswer18323Assessor Unavailable20775Caller Disconnected703Engaged208Partner Returned240Remained in IVR4090Ring No Answer140Transfer to Partner3881
The issue I have is that I need there to be a grand total at the bottom of the table rather than Excel having to do it. Is this possible?
Thanks for looking and thanks in advance for any help.