Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Filter, Rollup and Bin

I have this table:

 

DateTypeNameColorHeightLengthSales
Feb 1, 2021SofaWilloughbyLightTallWide1
Feb 1, 2021SofaPotomacLightTallWide2
Feb 1, 2021SofaBowenLightTallNarrow3
Feb 1, 2021SofaKingfisherLightShortNarrow9
Feb 1, 2021SofaMorgan DarkTallWide2
Feb 1, 2021SofaSanta FeDarkShortNarrow9
Feb 1, 2021SofaCostaDarkTallNarrow1
Feb 1, 2021SofaWhite MountainLightShortWide1
Feb 2, 2021SofaMorgan DarkTall Wide2
Feb 3, 2021SofaMorgan DarkTall Wide3
Feb 1, 2021TableHometownDarkTall  Wide2
Feb 1, 2021TableDakota DarkTall  Wide5

 

I have a silcer on Color, Height, and Length.

 

I also have a bin for Sales

Size
1-4
5-9
10+

 

I want to display a table that shows Date, Type and Size where Size is calculated as filter first, sum the sales by type and day and bin the sum.

 

Sample with no filter

 

DateTypeSize
Feb 1, 2021Sofa10+
Feb 1, 2021Table5-9
Feb 2, 2021Sofa2
Feb 3, 2021Sofa3

 

Sample with filter Length = 'Wide'

 

DateTypeSize
Feb 1, 2021Sofa5-9
Feb 1, 2021Table5-9
Feb 2, 2021Sofa2
Feb 3, 2021Sofa3

 

Sample with filter Length = 'Wide', Height='Short'

 

DateTypeSize
Feb 1, 2021Sofa1-4

 

Needing help!

Need Help