Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

QUESTION: in the table Dataset: Create a new column named % of Grand Total by using the appropriate Expression to divide the Total Units by

QUESTION: in the table Dataset: Create a new column named % of Grand Total by using the appropriate Expression to divide the Total Units by the SUM of the Total Units. Format the new column as percentage, 2 decimals.

image text in transcribed
- Sehajpreet Singh X power bi presentation SMS - Copy - Power BI Desktop Search File Home Help Table tools Column tools Name Trans # $%Format Whole number E Summarization Don't summarize Sort by Data Manage New 123 Data type Whole number $ ~ % 9 28 0 Data category Uncategorized column * groups * relationships column Calculations Formatting Properties Sort Groups Relationships Structure Fields > Dol X V Trans # * Year * Product_Code |Country * Units_Sold Search 177715 2018 PG4152 China 1095 177719 2018 PG4152 China 889 COUNTRY 177735 2018 PG4152 China 1068 City 177742 2018 PG4152 China 1058 177752 2018 PG4152 China 912 Country 177754 2018 PG4152 China 936 Latitude 177759 2018 PG4152 China 912 @ Longitude 177765 2018 PG4152 China 908 DATASET 177767 2018 PG4152 China 954 PRODUCT 177769 2018 PG4152 China 922 177775 2018 PG4152 China 1009 Product_Code 177798 2018 PG4152 China 889 Product_Descripti 177811 2018 PG4152 China 1074 Unit_Price 177813 2018 PG4152 China 824 177816 2018 PG4152 China 943 177827 2018 PG4152 China 771 177831 2018 PG4152 China 1034 177832 2018 PG4152 China 1025 177840 2018 PG4152 China 957 177845 2018 PG4152 China 1002 177866 2018 PG4152 China 858 177867 2018 PG4152 China 766 177870 2018 PG4152 China 955 Table: DATASET (284,212 rows) Column: Trans # (284,212 distinct values) 2:09 AM O W X 8 X P 074) ENG 2021-03-23 ED Type here to search

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals Of Financial Accounting

Authors: Fred Phillips, Robert Libby, Patricia A Libby

3rd Edition

0073527106, 9780073527109

More Books

Students also viewed these Accounting questions

Question

How do income taxes affect the break-even equation? Why?

Answered: 1 week ago

Question

Explain all drawbacks of application procedure.

Answered: 1 week ago

Question

2. Ask questions, listen rather than attempt to persuade.

Answered: 1 week ago