Bars in Bar Charts in an order

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I have Bar Chart in access database.

Rowsource for this chart is
TRANSFORM Sum(Chart_FD.CountOfUCCID) AS SumOfCountOfUCCID
SELECT Year
FROM Chart_FD
GROUP BY Year
PIVOT EQTMAN;
It works fine. But I would like to arrange the bars in an order of SumOf
CountOf UCCID descending. Trnasform Statement did not let me to Order by an
aggregate function. Is there any other way I can do this.

Thank you for your help.
 
I don't think there is any easy method for doing this. Since the
[SumOfCountOfUCCID] is grouped by Year, which Year's results would you use
for sorting?
 
It depends on which year the users selecting. They have the option to select
the year for last 5 years.

Thank you

Duane Hookom said:
I don't think there is any easy method for doing this. Since the
[SumOfCountOfUCCID] is grouped by Year, which Year's results would you use
for sorting?
--
Duane Hookom
Microsoft Access MVP


Lin said:
Hello,

I have Bar Chart in access database.

Rowsource for this chart is
TRANSFORM Sum(Chart_FD.CountOfUCCID) AS SumOfCountOfUCCID
SELECT Year
FROM Chart_FD
GROUP BY Year
PIVOT EQTMAN;
It works fine. But I would like to arrange the bars in an order of SumOf
CountOf UCCID descending. Trnasform Statement did not let me to Order by an
aggregate function. Is there any other way I can do this.

Thank you for your help.
Click to expand...
Click to expand...
 
If they only select a single year then you might try change your Row Source to

SELECT Sum(Chart_FD.CountOfUCCID) AS UCCIDCount
FROM Chart_FD
ORDER BY Sum(Chart_FD.CountOfUCCID) DESC;

--
Duane Hookom
Microsoft Access MVP


Lin said:
It depends on which year the users selecting. They have the option to select
the year for last 5 years.

Thank you

Duane Hookom said:
I don't think there is any easy method for doing this. Since the
[SumOfCountOfUCCID] is grouped by Year, which Year's results would you use
for sorting?
--
Duane Hookom
Microsoft Access MVP


Lin said:
Hello,

I have Bar Chart in access database.

Rowsource for this chart is
TRANSFORM Sum(Chart_FD.CountOfUCCID) AS SumOfCountOfUCCID
SELECT Year
FROM Chart_FD
GROUP BY Year
PIVOT EQTMAN;
It works fine. But I would like to arrange the bars in an order of SumOf
CountOf UCCID descending. Trnasform Statement did not let me to Order by an
aggregate function. Is there any other way I can do this.

Thank you for your help.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top