Hi all,
I am having bit of a trouble finding the period number in which max quantity was sold. I want to create a table in which I can show Period(Quarter/Month/Week) - Year wise maximum quantity sold.
In the above image(1) I have highlighted the maximum quantity sold in each year. I can also select period by parameter image(2) .
In the above table I want to show the month number in which maximum sales was made. Please suggest me what can be done to achieve this.
Any help would be appreciated.
Dataset used : Sample_super_store
Here's the link for my tableau's workbook : https://public.tableau.com/views/Max_sales_in_period/Sheet3
https://public.tableau.com/views/Max_sales_in_period/Reference_to_period
Thank you.
PS: Spare me if I have missed out any detail, this is my first post
please see the attached red tabs
done with LOD - wanted to avoid table calculations
these are the formula
and
it will return this