7 Replies Latest reply on Jan 8, 2017 9:55 PM by suhas doke

# SHOW HIGHEST SALES IN EVERY MONTH OF PARTICULAR DATE

HI,

My scenario is  I have one year data, i want get result every month of maximum sales in every month of particular date(max sales in one date of month)

ex:

if 15-jan-2016 have highest sale and 5-feb-2016 like

i want get each of date of month max sales in a year

I have attached how result we want

thank you

• ###### 1. Re: SHOW HIGHEST SALES IN EVERY MONTH OF PARTICULAR DATE

Hi Tarun,

LOD to the rescue!! Create a calculated variable which finds out if the date is the date having maximum sale in month for a given year. Please refer the attached sheet. I have used the Superstore data.

1. "Month Max" is the calcuated variable which uses the LOD and finds out if the max sale corresponds to the current row date sale.

[Sales] = { FIXED YEAR([Order Date]),MONTH([Order Date]) : MAX([Sales]) }

2. Put the Month Max on the filter shelf and select only True values.

3. Put Order Date  and SUM(Sales) on row and column shelf

Good Luck!!

Suhas

• ###### 2. Re: SHOW HIGHEST SALES IN EVERY MONTH OF PARTICULAR DATE

I have used Include & Exclude LODs to obtain the solutions. Please use the Max Sales, Max Date Filter and Day Sum Sales calculated fields from the linked sample workbook to understand the solution.

• ###### 3. Re: SHOW HIGHEST SALES IN EVERY MONTH OF PARTICULAR DATE

Thank you so much Shivannna

• ###### 4. Re: SHOW HIGHEST SALES IN EVERY MONTH OF PARTICULAR DATE

Thank you so much suhas doke

• ###### 5. Re: SHOW HIGHEST SALES IN EVERY MONTH OF PARTICULAR DATE

can u please send ur refer sheet,Here refer sheet was not received

• ###### 6. Re: SHOW HIGHEST SALES IN EVERY MONTH OF PARTICULAR DATE

Tarun, I would like to clarify my solution, Max Sales on my workbook is the total sales of all products on the highest sales day, while Suhas Doke's solution is giving you the highest sales of a product and not the sum of all products for that day.

• ###### 7. Re: SHOW HIGHEST SALES IN EVERY MONTH OF PARTICULAR DATE

Hi Tarun,

PFA the required sheet. If you still don't get it. Please send your email and I will mail you the sheet.

-Suhas