I really appreciate your time and help on this matter. Thank you so much for that. I tried above two formulas and It did not work. I have created a file with small quantity of data. You can see it on here(new file with work).
If you have time, can you please tell me, what I have done wrong? I am still trying to get the same result, but my goal is to get in bar chart. so, I can drill down through category level.