year quarter month product sales$\_$amount

$2021$ Q$1$ Jan A $1000$

$2021$ Q$1$ Jan B $2000$

$2021$ Q$1$ Jan C $3000$

$2021$ Q$1$ Feb A $1500$

$2021$ Q$1$ Feb B $2500$

$2021$ Q$1$ Feb C $3500$

$2021$ Q$1$ Mar A $2000$

$2021$ Q$1$ Mar B $3000$

$2021$ Q$1$ Mar C $4000$

$2021$ Q$2$ Apr A $1200$

$2021$ Q$2$ Apr B $2200$

$2021$ Q$2$ Apr C $3200$

$2021$ Q$2$ May A $1800$

$2021$ Q$2$ May B $2800$

$2021$ Q$2$ May C $3800$

$2021$ Q$2$ Jun A $2200$

$2021$ Q$2$ Jun B $3200$

$2021$ Q$2$ Jun C $4200$ using this table i created schema on snowflake. now i need to Create a dice from cube on product A & C$,$ month having ODD

number and Quarter having EVEN number and execute the following opertions $-$

$1.$ Total Sale value by $-$

a$.$ Each Year

b$.$ Each Quarter

c$.$ Each Month

d$.$ Each Product

e$.$ Each Year,Quarter Combination

f$.$ Each Year,Month Combination

g$.$ Each Year,Product Combination

h$.$ Each Quarter,Month Combination

i$.$ Each Quarter,Product Combination

j$.$ Each Month,Product Combination

k$.$ Each Year,Quarter,Month Combination

l$.$ Each Year,Quarter,Product Combination

m$.$ Each Year,Month,Product Combination

n$.$ Each Quarter,Month,Product Combination

o$.$ Total Sales value.