Can anyone please tell me what function in excel I could use in this instance: I...

Can anyone please tell me what function in excel I could use in this instance: I have two spreadsheets with sales of products for a company. I am needing to create a new spreadsheet with gross sales by month and by region.

It haven't included all the worksheets, because I truly just need pointed in the right direction.

Solutions

Expert Solution

ANSWER:

As Sample spreadsheets are not provided, I have created two sample spreadsheets to solve the question asked.

I have provided the properly explained stepwise process in text and image format so you can easily implement the process.
I have provided the output image so you can easily cross-check for the correct output of the process.
Have a nice and healthy day!!

Step-Wise Process

Creating two sample spreadsheets, namely JanSale and FebSale
- JanSale

FebSale

Copy both sheet data into 1 Sheet, Namely Combined Sale

Using PivotTable to check gross sales by month and by region

a. First select complete data and Click PivotTable

b. Hit OK

c. Drag col names accordingly to your requirement

OUTPUT IMAGE

venereology answered 1 year ago

Next > < Previous

Related Solutions

Could you please tell me what it is？use what theroy？ Rather than exporting or FDI I...

Could you please tell me what it is？use what theroy？ Rather than exporting or FDI I can negotiate a contract that gives another company the right to make my product in their country.This is known as: When an immigrant sends money to his or her family back in their home country. (it’s difficult to measure) When more expensive goods sourced from inside a customs union replace the consumption of less expensive goods from outside the customs union. A situation in...

I need to fix this code, and could you please tell me what was the problem...

I need to fix this code, and could you please tell me what was the problem options 1 and 9 don't work #include <stdio.h> #include <time.h> #include <stdlib.h> // generate a random integer between lower and upper values int GenerateRandomInt(int lower, int upper){ int num =(rand()% (upper - lower+1))+lower; return num; } // use random numbers to set the values of the matrix void InitializeMatrix(int row, int column, int dimension, int mat[][dimension]){ for(int i =0; i<row; i++){...

please show me or tell me a trick, on how can i tell right away when...

please show me or tell me a trick, on how can i tell right away when a characteristics equation(system) is 1)overdamped 2)underdamped 3)critically damped 4) nonlinear show each an example write neatly!!!!!

Can anyone tell me about the measurement of ICP-AES?

How do I make a skewness and kurtosis graph in Excel? Can anyone provide me a...

How do I make a skewness and kurtosis graph in Excel? Can anyone provide me a step?

Hello Everyone, Can anyone tell me why my program will not run? I am trying to...

Hello Everyone, Can anyone tell me why my program will not run? I am trying to work on abstract base classes... not sure what is going on. import math from abc import ABC from abc import abstractmethod #TODO: convert this to an ABC class Shape(ABC): def __init__(self): self.name = "" def display(self): print("{} - {:.2f}".format(self.name, self.get_area())) #TODO: Add an abstractmethod here called get_area @abstractmethod def get_area(self): if self.name == "Circle": get_area()= 3.14 * radius * radius else: get_area() = self.length...

can anyone tell me the reason why if the number of basis is equal to the...

can anyone tell me the reason why if the number of basis is equal to the dimension of a vector space V then it is the basis of the vector space V. and also what the theorem is? since, I think if V=span{(1,0,0), (0,1,0)} and dim(V)=2 and basis={(1,0,0), (0,0,1)} which the number is also 2. but it is not the basis of V. So, can you tell where is the mistake. THANK YOU!

Can anyone please explain this table for me please. I need it very badly. thanks The...

Can anyone please explain this table for me please. I need it very badly. thanks The 95% confidence intervals for the student using cannabis in the last 12 months is as follows: Point Estimate Upper Limit Lower Limit Male 0.27 0.05 Female 0.35 0.09 Total 0.28 0.10

Can anyone tell me what this means? A motion for summary judgment is properly granted when...

Can anyone tell me what this means? A motion for summary judgment is properly granted when there are no triable issues of material fact and the moving party is entitled to judgment as a matter of law.

Okay, can someone please tell me what I am doing wrong?? I will show the code...

Okay, can someone please tell me what I am doing wrong?? I will show the code I submitted for the assignment. However, according to my instructor I did it incorrectly but I am not understanding why. I will show the instructor's comment after providing my original code for the assignment. Thank you in advance. * * * * * HourlyTest Class * * * * * import java.util.Scanner; public class HourlyTest { public static void main(String[] args) { ...

Subjects