calculating percentage of sales for promotions

**chandramouliarun** · 07-15-2019, 10:49 AM

Hi All,

Hope you are doing well!.. I have a dataset that has the vendor information along with if the vendor had sales promo (Yes)...Basically the Non promo sales is identified by No and the promo sales is identified by Yes...If the vendor has both promo and non promo sales it has both Yes and no and the overall sales is identified by the sum of Yes and No sales for the vendor...

Now I need to create the output in the (present in the second tab of my attached sheet....-Expected output)..

1) that identifies the vendors that have had promo's and calculates the total sales for 2 different timeframes , the promo sales for two different timeframes and calculate the percentage difference...
2) Now if the vendors sales is only through promotion Yes then its total sales is equal to the promotion sales..

Can you please help me with a Power query for this !..Really appreciate your help!!...

**Pepe Le Mokko** · 07-15-2019, 11:17 AM

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

**chandramouliarun** · 07-15-2019, 11:25 AM

Hi Pepe Le Mokko,

Apologies!..Yes i have changed the thread title

**JeteMc** · 07-17-2019, 10:29 PM

I believe this same question was asked in the thread linked below. Furthermore a proposed answer has been placed in that thread to which no response has been given.
https://www.excelforum.com/excel-pro...ml#post5154435

**Pepe Le Mokko** · 07-18-2019, 02:34 AM

Good show Jete

**Pepe Le Mokko** · 07-18-2019, 02:48 AM

Administrative Note:

Welcome to the forum.

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #5 about thread duplication.

I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-for...romotions.html

calculating percentage of sales for promotions

LinkBack

Thread Tools

Display

calculating percentage of sales for promotions

Re: Vendor Promotion Sales

Re: calculating percentage of sales for promotions

Re: calculating percentage of sales for promotions

Re: calculating percentage of sales for promotions

Re: calculating percentage of sales for promotions

Thread Information

Users Browsing this Thread

Similar Threads

Macro to identify vendors who had promotion Sales

Report with grouped/sub-totaled by vendor - Need vendor name and number on each txn

[SOLVED] Find Vendor with most sales

[SOLVED] A formula or function to calculate the sales promotion

Formula to check if a product is on promotion and calculate average sales

Sales Goals - using rolling 12 month sales and minimum monthly sales

Pulling selected data from multiple worksheets into sales summary by vendor

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions