- Joined
- May 28, 2016
- Posts
- 806
- Solutions
- 1
- Reaction
- 139
- Points
- 291
Good day po, baka may nakakaalam po jan kung paano kuhanin yung percentage of column total po based sa sql statement ko po
then ito yung output nung sql statement ko,
Then ang gusto ko po sana is ganito yung magiging output niya,
from this, (ni-"show values as" ko po siya as "%of Column Total" po)
to this po,
Sana may makatulong po, maraming salamat po.
Code:
SELECT Product, ROUND(SUM(Revenue),2) AS Revenue
FROM dataset
GROUP BY Product;
then ito yung output nung sql statement ko,
Then ang gusto ko po sana is ganito yung magiging output niya,
from this, (ni-"show values as" ko po siya as "%of Column Total" po)
to this po,
Sana may makatulong po, maraming salamat po.
Attachments
-
You do not have permission to view the full content of this post. Log in or register now.