Creating a dashboard with filtering condition

Hi,

I have a list of buyer purchasing data which consist of total quantity of the product and due date to ship the product.

I want to create a dashboard which can show the total quantity of product that will be shipped by month (e.g. January, February …December).

E.g. On the dashboard, when i click January, it will show me the total quantity of product that is due on January.

You would need to do two things… create a simple table with month names (only one column is needed). I assume that you have a date field in your table. Create a virtual column (Ref type) with an app formula into your purchasing data table…
SWITCH(MONTH([Date]),
1,“January”,
2,“February”,

11,“November”,
“December”)
If you now add both views to your interactive Dashboar view, it should work.

1 Like