Hi There, My DataRow IdDate dd-mm-yyyy Category101/01/2022Cat1201/01/2021Cat2301/01/2022Cat 2401/02/2022Cat 2 I wanted to create a chart view of categories vs month year ie a drop down to select Month year 2022 - 01 Then the category frequency pie ch...

My worksheet has following two tables Table 1 : Category category_id main_category sub_category Table 2 : Vendors vendor_id sub_category venodor_name Table 1 : Category Sample data as follows 1,ENTERTAINMENT,OTT 2,SHOPPING,SHOPPING_APPS Table 2 : Ven...

I have four depended filter Main Category Sub Category Sub Sub Category Sub Sub Sub Category So depends on main category I need to filter sub category. I have used folllowing formula in the Valid If property of Sub_Category SELECT( category[sub_categ...